dualhcsniatpac
Board Regular
- Joined
- Feb 18, 2009
- Messages
- 126
I have seen this on the net somewhere but I have been searching for the past 20 min and cant seem to find it again. I am looking to have my VBA code double check an input from my form. For example, when the form is submitted I want it to check all of the fields to see if they comply with the format that I want them .
Time will be in the format (military) - "0000 - 2400" Is the best way to do this by case??? (Is there a way to specify that the 2 last numbers must be between 00-59??)
Also what are the commands for taking someone back to the form itself. I was thinking about just a popup window.
Thanks any help will do
Time will be in the format (military) - "0000 - 2400" Is the best way to do this by case??? (Is there a way to specify that the 2 last numbers must be between 00-59??)
Also what are the commands for taking someone back to the form itself. I was thinking about just a popup window.
Thanks any help will do
Last edited: