Solved

Access Query (Time Slots Availability)

Posted on 2010-09-01
11
388 Views
Last Modified: 2012-05-10
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 :)
0
Comment
Question by:Rahul Sehrawat
  • 6
  • 5
11 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33579394
do you already have a form to enter the parameters ?

0
 

Author Comment

by:Rahul Sehrawat
ID: 33579449
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.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33579471
post the datatype of your fields from the table
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33579476
better if you will upload a copy of your db..
0
 

Author Comment

by:Rahul Sehrawat
ID: 33579529
Hey,

I have attached the file.

Availability Form is the Main One.

Thanks :)
booking.mdb
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33580162
test this


booking.mdb
0
 

Author Comment

by:Rahul Sehrawat
ID: 33580369
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 :)
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33580432
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...
0
 

Author Comment

by:Rahul Sehrawat
ID: 33580446
Sure. :)
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 33582683
test this thoroughly



booking.mdb
0
 

Author Closing Comment

by:Rahul Sehrawat
ID: 33583693
Program Is Working Great.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question