Recent content by quasimodo

how can i make a working clock which is synchronised with the system clock, to appear in a text box on a form?? Any help appreciated, thanks in advance....

please have a look at the attached pic... on the pic, u can see that on the design view of the form, GuestID, and BookingRef is on there, but in the table view they are not. The Visible and Enable properties of both GuestID and BookingRef are set to Yes, so how is it that this is happening...

thanks... but then the control source wouldnt be the GuestID record in the booking table, and as that needs to be present, an entry will not be able to be made in the booking table.... Anything else...?

try having the query search from the subform form, and not the subform on the main form...

i'm creating a hotel booking system. I have a booking form, which has guest details on it, and that particular guests booking details as a subform. I'm having a problem with the GuestID. Please have a look at the attached pic. The control source for the main source is the Guest table. The...

i got a form (in attached pic). The vacant rooms part (circled red) is part of the main form, and the customer part (circled blue) is a subform of another form. I need to be able to take the CustomerID from the subform, and the RoomNumber from the main form and add them to a Bill table. I have...

attached is a picture of one of my forms for a hotel booking/billing system.... the user selects the customer from the drop down list on the left, and the vacant room in which the customer will stay from the list on the right. How can i take these 2 selections and add them to the Bill...

PERFECT!!! THANK YOU SO SO MUCH!!!

here it is so far....

nup... i've managed to get a list of the rooms currently vacated, but i dont know how to get a list of vacant rooms from that list... so if anyone can help me with that, i'd be more than grateful...

cheers rich.... you couldnt help me with another problem could u? http://.....adid=44069

I need help with a query i'm having trouble with. Theres 14 rooms in the Rooms table. When som1 cheks in a record is made in a BillTable. There is more than 1 entry per room in this table, as all records of ppl staying are kept here. This bill table has a checkbox, which is ticked when a guest...

Rich - I couldnt find the post you are talking about. Any chance of a direct link please??

thanks for the suggestion, but there are records for ALL customers that have stayed at the hotel, so if i have the criteria as TRUE, it will bring up a list of all previous guests who have stayed at the hotel. I only want a list of all vacant rooms at any given time. My tutors suggested adding...

i'm making a hotel booking/billing system for my A-Level ICT coursework. I'm having trouble making up a query to show a list of vacant rooms. I've attached a pic of my tables and fields... When a customer comes to the hotel, they are added to the customer table (if new) or their record is...