md1274
03-30-2001, 07:38 AM
Hello everyone:
I'm creating a database that let the user click on an ActiveX control (calendar) and permit them to select an option of taking time off. The only problem is that if the user is trying to take the same day off and the hours equal 8, how can I code a find, seek and no match method to check to see if the user is selecting the same day off and the hours equal 8 to show a message box informing them that they can't take that day off.
I'm creating a database that let the user click on an ActiveX control (calendar) and permit them to select an option of taking time off. The only problem is that if the user is trying to take the same day off and the hours equal 8, how can I code a find, seek and no match method to check to see if the user is selecting the same day off and the hours equal 8 to show a message box informing them that they can't take that day off.