Room Booking

Mar 1, 2005

Hi All,

I am in the process of creating a Room Bookings database using the limited graphical tools of Access 2003.
I intend to break up the day from 0700 to 1900 into 48 X 15 minute chunks (the minimum bookable time) and have these graphically represented on the form as boxes whose colour change depending on whether it is booked and who by.
It would be normal to have up to 8 colours available for this as any one room would be unlikely to be booked by more than 8 people in one day.
I would envisage that each day would be covered by a separate subform.

Has anyone else tried a graphical representation of a booking form?

It would be interesting to hear others views or experiences...

Dave E

View Replies


ADVERTISEMENT

Room Booking System

Mar 31, 2008

Is there still a hotel/room booking system sample database available on the forum?

I remember seeing one a while back in the samples forum but can't find the thread now.

If it's not here anymore does anyone know of any samples I can look at?

View 5 Replies View Related

Queries :: Booking System - Finding Available Room For Date Range?

Feb 18, 2014

So I'm trying to do this database for my ICT coursework and its a full system for dog kennels.

So in actuality the rooms are kennels.

I have a table tblbookings that amongst others has fields:

Kennel No
Date In
Date Out

I need a way of users entering the requested dates for a new booking and getting an output of a list of all kennels that are available to book for that full date range or even better, a way of running this straight from the form for a new booking frmbookings to just leave the first available kennel no. in the field KennelNo?

View 5 Replies View Related

Forms :: Preventing Double Booking Of Room In Form Based On Multiple Criteria

Aug 13, 2015

I have Table for rooms called Rooms, and the data in the table is roomNumber which is in the format Letter and two Digit number, so A01 would be dorm building A and room building 1, and I then have a seperate row named roomType that is either VIP or Semi Private.

Now I am creating a form where a worker will put in there scheduledCheckin date and scheduledCheckout date and it will be written to the Bookings table. I would like this form however to take the dates they have put in, as well as room type (Semi-Private or VIP, and assign them an available room that isn't booked at all in that range) or list all available rooms for that range of time and they could then just select the room. I would rather it automatically assigns an available room based on room type though because this check in system is going to have about 500 rooms.

I've attached a link for what I have so far. I know how to make a query to list anyone who has booked rooms over that date, but need one for just preventing booking the same room.

[URL] .....

View 3 Replies View Related

Room Scheduler

Nov 15, 2005

I want to build a room scheduler. Before I get too far in to my first attempts, does anyone know if there any examples out there I can use to give me ideas?

If not I wonder can anyone advise me as to a difficulty I currently can see with what my attempts so far. I have built a very basic database with fields for each room and time slots through each day. This works ok. The problem I see is finding a way of setting a room booked for say "every Thursday between 14.00 and 15:00". I have considered using a query to do it but cannot see how to formulate it.

Thanks in advance for any help you may offer.

Peter

View 2 Replies View Related

Help On Room Filter

Mar 4, 2008

Hi

I currently am in the the middle of creating a database to hold details of computer hardware in stock.

I have created a query which simply lists all the items in the main table, then a form pulls the infomation from the query and displays all the items.

On the main page I have some buttons labled Room1,Room2,Room3...etc

What I am wanting to do is to press a button and it show the form but only the items from that room.

I could do this by creating many querys and then forms and having each button link to its correct form however this isn't ideal.

Does anyone know how to get the form to display only items from the query that are set by each button

Thanks
Chris

View 2 Replies View Related

Room Scheduling

Nov 8, 2005

Can anyone point me in the direction of a room scheduling example or a tutor site. I originally wanted to use Outlook but my boss, after seeing another Acces Project I did, asked for it in the Access. I can build a basic data base on a daily basis showing rooms against hours, but my problem is forward scheduling eg "every Thursday meeting room 1 will be for Group A" etc. Can anyone please get me started - I'm tearing my hair out on this one!

Thanks in advance.

Peter

View 1 Replies View Related

Hotel Room Availability Query

Feb 22, 2007

Hi Everyone,
hope someone out there can figure this one out.


I am developing an access database and forms based on a hotel booking system.
There is a tblRoomState table, which holds the roomID, the date and the state of the room, (so for a 3 night stay, this table holds three entries).
I have a query which returns any roomID's from the tblRoomState table which have a state value of 1 at a specified date.
I want to run another query which returns roomID's from the tblRoom table which are not part of the recordset of the first query.


Since there is no records held in the database for rooms which are not booked, the only way to access "availability" is to use a recordset of rooms which are booked and test against that.

Thanks,
John

View 9 Replies View Related

Accommodation Database - Availability With Shared Room Capacity

Feb 6, 2007

Hi,
I have been reading throguh various articles and learning a lot from you guys, so thank you very much. This place is a fantastic source of information, by far the best of anything i have found online.

I have a question which i would be grateful if someone could advise upon.

Access 2003. I have 4 tables:

list_accommodation (holding host family address details who offer accommodation to students)
id (autonum)
name (text)
address (text)
etc.....

list_rooms (table of rooms offered by host families)
room_id (autonum)
host_id (number) - joined to list_accommodation.id
room_name (text)
capacity (number)

students (student contact details who want accommodation!)
id (autonumber)
name (text)
dateofbirth (date)
address (text_
etc.....


bookings_accommodation (to hold the accomm bookings)
booking_id (autonum)
room_id (num) - joined to list_rooms.room_id
student_id (num) - joined to students.id
start_date (date)
end_date (date)

This structure therefore enables me to query if rooms are booked between dates:

SELECT bookings_accommodation.room_id, bookings_accommodation.start_date, bookings_accommodation.end_date
FROM list_rooms INNER JOIN bookings_accommodation ON list_rooms.room_id = bookings_accommodation.room_id
WHERE (((bookings_accommodation.start_date) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d",-1,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR ((([end_date]-1) Between DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date]) And DateAdd("d","0",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date]))) OR (((bookings_accommodation.start_date)<DateAdd("d",0,[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_start_date])) AND (([end_date]-1)>DateAdd("d","-1",[Forms]![workflow]![workflow_sub_add_accom_booking]![cbo_end_date])));


and therefore, using the 'booked' query i can therefore find out rooms are available.

SELECT list_rooms.room_id, list_rooms.room_name, list_rooms.capacity, list_rooms.description, list_rooms.host_id
FROM list_rooms LEFT JOIN qry_rooms_reserved ON list_rooms.room_id = qry_rooms_reserved.room_id
WHERE (((qry_rooms_reserved.room_id) Is Null));

----

so, now i have found out that there is a necessity to enable students to share a room (the bookings for a room may not happen at the same time). This means that i have to determine the capacity of a room and therefore if
the capacity is not full, then show as available.

I was wondering what the best approach to this may be?
I have added 'capacity' to list_rooms, but i am unsure as to how to go from there....

Any thoughts and advice woudl be really appreciated.

Many thanks

Phil.

View 2 Replies View Related

Queries :: Calculate Base Income Per Room Type

Apr 24, 2013

I have to create a query to calculate the Base Income per room.

Guest 1-4 is the standard room rate say $125/day, guests 5 & 6 pay additional $20 charge per day. Guests staying for seven days or more receive a 10% discount. How to build this expression into a query in access. If it was Excel that would be easier.

Table info I have is:
Room
Arrival Date
Departure Date
No of Guest (per room)
Daily Rate

View 6 Replies View Related

Stop Booking Twice Help Please!

Apr 22, 2006

Hi, im struggling with my project. I'm not sure how to pursue this, but when i a customer to book a lesson, i want the booking to be not booked twice.

So i have to prevent the date of when the customer wants his/her lesson to be booked on the same day as the other person.

I'll be very very grateful if anyone can help me with this.


Thank You!

View 1 Replies View Related

Help With Double Booking

Mar 7, 2008

Please could someone give me help on this topic, I need to slove it for coursework in Access but im having the following problem.

Im creating a database for a hotel which rents out its room obviously. The problem i have is if a guest books a room for say march 3rd until march 6th, theres currently no way in which to stop another guest booking the room for any of these dates.

I think i know how to stop double booking for the start day, but not the days inbetween if you understand.
The database has 3 tables:
Guest Info
Room info
Bookings

If anyone can help it would be greatly appreciated.

P.S the method i hope to use, is the hotel will enter the start date of a guests stay and then enter the number of nights the guest is staying for e.g. 3rd-6th of march would be input as: Begin date: 03/03/08 for:'3' nights.


Thanks for any help

View 9 Replies View Related

Booking Database Can You Help? Please

Apr 4, 2008

Hi :o

I have been asked to ceate a customer booking database for the computer stations and my mind has gone a complete blank. I have all my other tables but just can't think how to do it. I have 10 computers and they are booked hourly, Monday to Friday but each day finishes at a different time.

Can anyone please help I'm suppose to have it done by Monday. :eek:

Thanks in advance. :)

View 1 Replies View Related

Booking Form Help

Apr 16, 2005

Hi
I have a database which uses a form to book appointments, new or existing customers are booked in this way, or not as this case may be.
I have designed the form with my three options to book someone in, that are a Date, a Time and the treatment.

My date is taken from tables containing the appropriate dates for any Monday, (No Tues) another table for Weds etc until Sat for the next 4 years
My Time is taken from one table containing appropriate times in the day.
My Treatment is taken from a table containing a list of treatments.

How can I book an appointment without duplicating dates and times?
How can I produce a list of these bookings either daily, or weekly to forward these details via Microsoft Outlook?
I hope I am not asking for too much as I have been trying to do this on my own now for a while and have searched the board.
I have got this far so I don't want give up now.
Many Thanks
Bern :confused:

View 4 Replies View Related

Double Booking HELP

Oct 17, 2004

I am wanting to prevent a double booking. I have a form called:

frm_Booking which records an ArrivalDate and DepartureDate

and another form

frm_Building_Booking which records a BuildingID number

I want to ensure that a customer cannot book a BuildingID for an ArrivalDate and DepartureDate it it has already been booked by another cusotmer or book any on the days between.

However a customer should be able to book a BuildingID on the DepartureDate.

View 1 Replies View Related

Computer Booking Form

Sep 30, 2006

Hello,

For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.

Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:

Any other comments or suggestions are welcome too if there is a better way of doing this.

Thanks, ieuuk

View 3 Replies View Related

Pls Help, Double Booking Problem.

Jan 14, 2008

could someone please help me, i am having a problem trying to get rid of double bookings in the attached database.

This database is for an assignment for my students, and unfortunately i had got the point now that i have got incredbily stupid and cannot see a solution.

I want to make sure that a client cannot double book an instructor and a car on a specific time or date...

Obviously i would also want to make sure that if one client has booked a specific car or instructor no other client would be able to book it, in the same time and date slot.. All lessons are 1 hour long

for some reason i have to make sure that a client can book a specific car...
This unit is being taught alongside another unit by another teacher, who does not see the complexities of the problem, and insists that this complexity is in the database, however they do not know the solution either.

I have tried creating different types of primary key combinations, but that does not work..

Any ideas or suggestions would be greatly appreciated

View 14 Replies View Related

Instructor Booking System

Mar 8, 2008

I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and hopefully display a daily screen with a grid showing who is booked out with who at various time of the day.
Can anyone suggest some piece of freeware or example database to get me started?

Many Thanks

View 3 Replies View Related

Booking Too Far In Advance Or Too Close

Mar 24, 2006

Hello everyone, if anybody could help me I'd deeply appreciate it.


Booking ID = the time when it is booked over the phone
Hiring ID = the time when the event is to be held

Basically I have to make some booking dates, and use January and February 2006 as test data. My only dilemma is it says that the booking dates must not be booked more than 8 weeks before the hiring, and at least 1 week before it. So if someone wanted to the hiring for 01/01/06, then they wouldn't be able to book before 01/11/05, but before 25/12/05. Can anybody help me? Thanks. I need it so that whatever the hiring date is, the booking date has to be no more than 8 weeks in advance, but 1 week before the hiring.

View 4 Replies View Related

Venue Booking Ideas Please

Mar 23, 2006

Firstly can i say Hi to everyone on this board amazing I registered today because it took this board 3 search to answer a problem Iv had for 2days now. So big thank you !!

No then Im creating a small website where members are capable of booking the Venue via the website. At the moment my databse consists of
Members_tb with attributes

Member_Id (Primary Key)
USer_Name
Password
Frist_Name
Surname
Address
Email

I am hoping someone from this board can help me by shedding some light as to how they would go about empowering a Member to book the venue for a particular date also taking into note not to book for a date the venue is already booked for.

Any help at all will be so much help. Im just confused as to how i should tackle this issue

View 1 Replies View Related

Simple Client Booking

Sep 24, 2007

I need to set up a simple Consultant Booking DB.

Consultants need to be able to log-in when they are available and be put in rotation. Agents need to be able to select the next available Consultant. I also need there to be a waiting list.
I would like to be able to run reporting on Time on Waiting List, Time with Consultant, etc.

Is there a simple way to do this? I would appreciate if someone could point me in the right direction.

Thanks

View 2 Replies View Related

Seat Booking System For Theatre

Feb 27, 2007

Hi hope someone can help me out here,

I have been asked to research and then produce a simple seat booking system for a movie showing in a small lecture theatre using MS Access. I'm a relative Access newbie and have had little luck in finding information on how to go about producing this system.

If anyone could provide or link me to anything which could be of use that would be great.

Many Thanks,
Ross.

View 5 Replies View Related

Double Booking Property Problem

Mar 8, 2007

Hi

I have created a database to take bookings for holiday properties but can't figure out how to stop the properties from being booked over the same period. I have a table called booking order with the fields Booking no, property no, start date and end date. On the equivilant form for a property i need to be able to stop start and end dates being entered that are between existing start and end dates already booked for that property.

Thanks for your help

View 5 Replies View Related

Seat Booking Problem, Help Needed.

Apr 15, 2007

I have been trying to develop a system by which a air flight company can book seats on a plane for passengers.
I am having the problem with one of the requirments though, in that I cannot figure out how to display all the seats on a flight, as well as the ones that have already been booked.
This is required so that a form can be created for the user, so that they can give information back to customers on whether there is availble seats of their class type or not.
I have attached the database with this thread, if anyone could be of any assistance, it would be greatly appreciated.
Andi.

View 14 Replies View Related

Relationship Of Airline Booking System

Mar 30, 2007

Hi,

I am going to do an online airline reservation system, and the database is going to be done using MS Access. The database contains 4 tables: Customers, Payments (Credit Card details), Booking, Flight.

Can someone help me do the relationships among the tables.
My personal e-mail is russcami@yahoo.com.

Thanks in advance.

View 1 Replies View Related

General :: How To Prevent Double Booking

Jan 23, 2013

On Microsoft Access 2010, I am creating a database project for a DJ booking system (not for professional use) and wondered how you can stop double booking from occurring that would provide you with an error message that I could personalize.

My current booking file looks like this:

Booking ID - Primary Key
Customer ID (Linked to customer table)
Venue ID (Linked to venue table)
Date Booked
Set Up Time
Start Time
Finish Time
Party Type
Discount Code

At the moment I have the date booked as Indexed (No Duplicates) however this gives me a long error message that I can not personalise.

Access 2010...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved