Testing results from inputbox for a date

[welchs101]

I have this code

Please Login or Register  to view this content.

Note: end_qrybcklog is at the end of the subroutine.

Problem is that then the "if" gets executed i get a run-time error.

how to test input from inputbox. if user hits cancel i want to exit.

[Mordred]

Hi welchs101, your code looks sound and runs without error for me. Perhaps there is a problem somewhere else in your code that is throwing the error there.

[welchs101]

I forgot to mention taht "start_date1" is a data type of "date"

dim start_date1 as date

sorry about that.........really sorry.



The only thing i could figure out is the following test:

Please Login or Register  to view this content.

[Mordred]

Hi welchs101, I think you need to have the"start_date1" variable declared as a string and then in your code convert it to a date after the input box. I just tried running it while declared as a date and it wouldn't work. Try adapting this to your code:

Please Login or Register  to view this content.

[royUK]

Maybe

Please Login or Register  to view this content.

[Mordred]

The following code also includes handling the inputbox if the user selects cancel:

Please Login or Register  to view this content.

[Mordred]

Hi RoyUK,

Maybe

Please Login or Register  to view this content.

This throws an error if the user doesn't input a date "Run Time Error 13, type mismatch"

[royUK]

I don't get an error with Cancel or inputting numbers. Input letters & it will error

Please Login or Register  to view this content.

[welchs101]

Mordred, i modified your code slightly and well, its not working as i would have expected.

Here is the code:

Please Login or Register  to view this content.

Problem is this: If you input say "5/1/11" what gets out put to the screen is this

12:00:00 AM

which is not 5/1/11


any thoughts? Ideas?

[Mordred]

Try:

Please Login or Register  to view this content.

[welchs101]

Thanks.

but when i hit escape i get an error.

[Mordred]

I don't know if this is the best way to go about this but I'm sure someone will tell us if it isn't:

Please Login or Register  to view this content.

[welchs101]

Thanks for the code.

I found something online about checking for the value "False" as a way of checking if they hit cancel

so here is the code

Please Login or Register  to view this content.

it seems to work.......no issues as yet

thanks again for your help

[welchs101]

royuk,

just an fyi: I also am trying to get your code to run.....good to learn something here.......anyway, yours always executes the "Not IsNumeric"......i guess this is always true. as such it never gets to the 3rd if then statement.