Search results

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...

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...

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...

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...

I'm having problems with a subform. I have a parameter query (used to search). How can i get the results to be displayed in a subform, rather than in a new window? I've tried putting the control source of the subform as the query, but this runs the query staright away when the main form is...

One of the options of payment I have is by credit card. How would I verify the entered card number to make sure its been entered correctly?

I'm have a phone call table, which i have made into a form. I've entered a formula to calculate the duration of the call and this works perfectly on the form, but doesnt get displayed on the phone call table. What do i need to do so the duration calculated also ends up on the table. There are...

I'm doing a hotel booking system on Microsoft Access. I have a form for recording any messages onto a message table. On the form, I have a search button on the form, for the receptionist to search for any messages for a particular room. Its a parameter query, and when the button is clicked, it...

I'm currently doing a project on a hotel booking system. I am using Microsoft Access to implement my system on. :confused: I'm having trouble with the room number field. Its got to be a 2 digit number. If I put the input mask as "00", Access takes away the beginning zero when I try and enter...