VBA Code - Prevent double booking

[chrisgunny]

Hi All,
Really need some help with code to prevent double booking in my database I was planning on using the BeforeUpdate function on the data entry form, the details are:

I have a table called "BookingsT" it contains the following fields the code needs to work with:

"RequestedDateFrom" - Date Field

"RequestedDateTo" - Date Field

"AssetID" - Number field which is pulled from "AssetT" table which lists my assets, the form inputs the number from the asset description which the user selects in the form.

"BookingCancelled" Yes/No field when yes the code should ignore these records.

The logic is simple:

If someone books Asset 1 between 15-4-13 and 16-4-13, someone cant then book asset 1 between 16-4-13 and 17-4-13, however if the first booking is cancelled then someone can book asset one from 15-4-13 or 16-4-13.

Hope thats enough info, any help would be great.

 

[spikepl]

http://www.baldyweb.com/OverLap.htm

 

[jdraw]

You may get some ideas here as well
http://www.datawright.com.au/access_resources/bookings_without_clashes.htm

 

[chrisgunny]

Thanks...kinda helps but I am not using times and that looks far more complex than what I need - I'll keep reading until I find something that works or the penny finally drops LOL