hi guys nice site you got here.

I need a bit of help its been over 2 years since I used access in college so have forgot most things.

I want to stop people from making double bookings at the same time on the same date.

I have the following

Booking ID
Teacher ID
Class Room ID
Date Booked
Booked Date
Start Time
End Time

so the booked date, start time and end time is what I need to look but not sure, should I index (no duplicates) for them three?

thanks for the help

I realise there are posts about bookings but more help would be great :)

What you need is a "collision checking " routine.

I did a Google, because I know there are some routines around, but all I got was stuff on robots!

So I found the example I have on my machine, In the hope of providing you a link. However the link no longer works.

The details I have are:

The Following found at: (SEE LINK BELOW)

Anita Smith's SQL Learning Tool
Anita Smith's SQL code tester. Bang in your code with the help of list boxes of available tables and fields. Select from SQL commands which are automatically pasted to the SQL window with prompts for appropriate info. Then test it! Nice help for SQL commands. Anita can be contacted at ozdane@dragnet.com.au
Download SQLWizrd.zip 74KB
Back to Top


(this link works, but the collision checker is not listed)
http://www.geocities.com/nealakling/Download.htm

I can send you Anita Smith's collision checker, but I don't want to post its in a public forum because I don't know why it was removed. I may be infringing someone's copyright.

There are also other versions of "collision checking" around it's just a case of finding them!

thanks dude, I'll do a bit more search.