Rahul Sehrawat
asked on
Access Query (Time Slots Availability)
Hey
My Table Structure is something like this:
conference_hall_name
date
timefrom
timeto
username
I want a query where user can check the availability of room according to the time.
I want the user to input Conference Hall, Date, Timefrom and Timeto
If the room is booked, it will show a msgbox showing room is booked by "username", else it will show "It's Available"
Is it possible?
Thanks :)
My Table Structure is something like this:
conference_hall_name
date
timefrom
timeto
username
I want a query where user can check the availability of room according to the time.
I want the user to input Conference Hall, Date, Timefrom and Timeto
If the room is booked, it will show a msgbox showing room is booked by "username", else it will show "It's Available"
Is it possible?
Thanks :)
do you already have a form to enter the parameters ?
ASKER
Yes!
Form Name: Availability_Form
Text Fields:
conference_room_name
meeting_date
time_from
time_to
I want to check the availability on click event of the button.
Thanks.
Form Name: Availability_Form
Text Fields:
conference_room_name
meeting_date
time_from
time_to
I want to check the availability on click event of the button.
Thanks.
post the datatype of your fields from the table
better if you will upload a copy of your db..
ASKER
ASKER
Hey,
The file is not working perfectly.
Issue is:
Example:
Demo Data Has Booking for 28-Sept-2010 from 10:30 to 11:30
If I Enter Data As
From Time: 10:25 to 11:40 - It show's Booking Available Should Be Already Booked
From Time: 10:25 to 11:25 - It show's Booking Available Should Be Already Booked
From Time: 10:35 to 11:40 - It show's Booking Available Should Be Already Booked
If I Enter Time Between the Booked Timing, Then only it shows that It has been Booked.
Thanks :)
The file is not working perfectly.
Issue is:
Example:
Demo Data Has Booking for 28-Sept-2010 from 10:30 to 11:30
If I Enter Data As
From Time: 10:25 to 11:40 - It show's Booking Available Should Be Already Booked
From Time: 10:25 to 11:25 - It show's Booking Available Should Be Already Booked
From Time: 10:35 to 11:40 - It show's Booking Available Should Be Already Booked
If I Enter Time Between the Booked Timing, Then only it shows that It has been Booked.
Thanks :)
ok. we need more criteria in the where part of the query. i'll be out for a while. we'll continue when i come back...
ASKER
Sure. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Program Is Working Great.