wizcow
Registered User.
- Local time
- Today, 12:17
- Joined
- Sep 22, 2001
- Messages
- 236
Hi
As I enter tickets into my invoice, I enter the ticket date and the straight time hours.
I would like to have access check to make sure I do not enter more than 8 hours on any one day.
I think it should be something like this....
If straighttimehours < 8 (for this date) then
msgbox "You have more that 8 hours entered"
end if
I'm having trouble writing the date part of this code.
Help!
Tom
As I enter tickets into my invoice, I enter the ticket date and the straight time hours.
I would like to have access check to make sure I do not enter more than 8 hours on any one day.
I think it should be something like this....
If straighttimehours < 8 (for this date) then
msgbox "You have more that 8 hours entered"
end if
I'm having trouble writing the date part of this code.
Help!
Tom