First I want to thank everyone who helped with my last problem. I got everything to work out well.
On the same project that I am working on I have a field, confirmation number, where myself and team tech enter a confirmation number. On enter of this field you get a input box for the confirmation number. I have the code counting to make sure the user enters 11 digits.
From that I want to take the confirmation number, ex 12150125982 (which is 12:15) and make sure that the number is greater than 12000000000 (12 noon) and less than 12300000000 (12:30 pm). If so set ckbInWindow = true.
I have to do a check like this for 6 different times.
Like I said before I am new to access and learning a lot. I did a search in the forum but did not find anything that I think would work easily or that I understood completly. :-)
Please take my thanks in advance for any input, comments, or solutions.
and you won't have to worry about confirming the time each time.
Make sure the control/variable MySevenDigits is looking for string data, or you won't be able to concatenate the numbers properly.
FYI The reason you format the "minutes" in the Time() function as "nn" and not "mm" is because "mm" is used for the two-digit month, not the minute. See the Format() function in the Help File for details, and make sure you read the examples.