Search results

Thanks Jon. The staff works FINE!!!! You have been a great help. Thank you very much Tony

Thanks Jon for your help but I have some bad news. Yours sample query doesn't really work. If you try searching for a flat that is booked from 16/03/2003-20/03/2003 for a CheckInDate on the 15/03/2003 and a CheckOutDate at 22/03/2003 returns that apartment as available, where it shouldn't .

I have the same problem with yours. Did you manage to resolve the issue yet? If yes, could you please help me? Cheers

the relationship between Flats and Bookings is a many to one. A booking is associated with only one flat while a Flat is can be associated with more than one Booking. P.S. There isn't a record for each date

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

Could you please tell me explicitly what do you mean, as I am a novice in Access. Can you please make the corrections on the code that I have supplied. I would be very greatfull as I really truggle with this one. Thanks

Just in case that I didn't clarify my intentions. What I would like is that instead of having the standard Access errors being displayed, to have the errors but with my words that the end user will understand, as my system will be deployed in a company.

I have tried it but again it doen't work. I will give you all the details below: 'In the class module Option Compare Database Option Explicit Dim gPendingError 'On Current Private Sub Form_Current() gPendingError = False End Sub 'BeforeUpdate Private Sub Form_BeforeUpdate(Cancel As Integer)...

The first error disappears but the second error still comes up. Here is my code: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo ERRCONTROL Cancel = True Exit_This_Sub: Exit Sub ERRCONTROL: MsgBox "Error: " & Err.Number Resume Exit_This_Sub End Sub Can you please tell...

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