33:50 time You put in duplicate dates for Joe. He worked from 9a-4p on 8/26 and 9a-10p on 8/26. How do you prevent those duplicate entry dates?
Reply from Rick Rost:
Vicki, the short answer is: you really can't without some programming which is much more advanced than we're going to cover at this level.
You'd need an AfterUpdate event to perform a DLOOKUP calculation to see if that particular timeslot already has an entry. We'll talk about this in the Advanced lessons.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 12.
