I am writting a db to monitor my machine capacity. Suppose I have 3 machines A, B and C, I create a form to the user to register/book the machine before they use. Let's say I register machine A on 12.12.2002, 15:00-17:00, another user might register with machine A too on 12.12.2002, 16:00-18:00. How to make the db prompt for time/schedule conflict in this case? Please advise. Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Registration time crashes.
- Thread starter 8206276
- Start date
Asuming that you are recording the start and end time in seperate fields. Create a recordset that for the given day pull any record where the new start or end time is between tany existing start and end time. Then just test the result test for number of records returned. If greater than 0 a conflict else if no records returned, no conflict.
Good Luck
ssecca
Good Luck
ssecca
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question