I’m new to Access and this forum. I just started using Access about a year ago and really enjoy working in it. But I’m not whiz kid at it and any help is much appreciated.
My friend took over my old job and asked me to help him with room scheduling. Previously they were using Excel for room scheduling but that takes up too much of his time. I’ve put together a database but here are the two issues I come across:
1. How do I prevent a double booking? (Besides the obvious of not entering the same info
)
I have a form which allows the user to book rooms. On this form are the following fields:
Count: (Autonumber)
ProgramCode: Text box
DivisionCode: Text Box (drop down box)
Event: Text Box (drop down box)
Room: Text Box (drop down box)
StartDate: Date/Time
EndDate: Date/Time
StartTime: Date/Time
EndTime: Date/Time
NumofSessions: Number (this is a calculated field - for show only)
Semester: Text Box (drop down box)
Year: Text Box (drop down box)
The form adds this information to the Schedule table.
2. How do I have the form check to see if events overlap? If it does overlap, I want the proposed booking to be rejected with a customized message.
Thanks
My friend took over my old job and asked me to help him with room scheduling. Previously they were using Excel for room scheduling but that takes up too much of his time. I’ve put together a database but here are the two issues I come across:
1. How do I prevent a double booking? (Besides the obvious of not entering the same info

I have a form which allows the user to book rooms. On this form are the following fields:
Count: (Autonumber)
ProgramCode: Text box
DivisionCode: Text Box (drop down box)
Event: Text Box (drop down box)
Room: Text Box (drop down box)
StartDate: Date/Time
EndDate: Date/Time
StartTime: Date/Time
EndTime: Date/Time
NumofSessions: Number (this is a calculated field - for show only)
Semester: Text Box (drop down box)
Year: Text Box (drop down box)
The form adds this information to the Schedule table.
2. How do I have the form check to see if events overlap? If it does overlap, I want the proposed booking to be rejected with a customized message.
Thanks