I have made a MS Access Database and need to prevent double bookings?

Question

Fields are as followed:
1) Date Booked for
2) Start Time
3) End Time

Thanks in advance for any help

Answer 1

First thing is to check for the date.
If that equals date of pending booking do check on times
And you've got to loop through all the bookings you already made. Mabye do a check on inputting start and end times so that start is less then end.
sub checking()
For every record in your file 'do while not .eof. ?
if date = bookingdate then
if starttime < pending booking time start then
if endtime < pending booking time start then
bookable = true 'bookable is a boolean variable
else
bookable = false
goto notbookable
endif
else
if startime > pending booktime start then
if starttime > pending booktime end then
bookable = true
else
bookable = false
goto notbookable
endif
else
bookable = false
goto notbookable
endif
endif
else
msgbox "booking can be made"
exit sub
endif
next record
:notbookable
msgbox "booking can't be made"
end sub
With some tweaking this will loop every record in your file. If bookable is still true then booking can be made. If bookable becomes false the loop will exit and message will show up that booking can not be made.

Test a little before implementing.

Answer 2

ur question is not clear, but i think it is related to "query" in MS Access

Answer 3

could u explain more