Search results

I have two tables, Flats (FlatID, Court_No, Flat_No, Description) and Bookings (BookingID, FlatID, CheckInDate, CheckOutDate). The Flats table contain 19 flats that a company has and the Bookings table stores the bookings for a customer. What I would like to do is to devise a query that will...

I have a main form, with 3 input fields where the user can enter their search criteria and click on a search button to display the results on the same form, in the form of a datasheet subform. What I would like to do is to be able to select on of the results given and output the results on...

I have a form with four input boxes, all of which are required and two buttons, "OK" and "Cancel", for storing information in a table and closing the form respectively. I have managed to get my error trapping code to work for the above 2 buttons, but when I try to close the form from the "X"...