Search results

Hi guys, In my customerpostjourney form, I have a journey start time field, a journey end time field and a total time field. In the form design view, I entered into the total time field "=[Text23]-[Text21]". This, in the form, displays the total time correctly, however it does not store the...

Hi, At the moment I have a report which shows vehicles, the action required (MOT in this case), the last renewal and the next renewal as shown below: Basically, I need a message box to appear to the user when the next renewal date is within 60 days of today's date, for example it could say...

Hi there, I have a query (vehicleavailable) which uses parameters boxes so that the user can search for available vehicles for a certain date and time. However, I need to link this to a dropdown box / list box in a form so that when the user creates a booking, they can only select the vehicles...

Hi guys, I am using some SQL code in a in a vehicle booking database which shows the user in a seperate form which vehicles are available to be booked for a select date. However, I really need to make it so it does this by date AND time. Does anyone know how I could modify my code to enable...

Hi, I have a main form with a subform inside it. The subform contains two records but only one is shown during form view, is there any way to show both records at the same time? I am using continuous forms view for my subforms as i have to.

Hi, I have a form that is based on a query which looks up values in three different tables. I also have a subrform which looks up order information from the tables, all in the same form. I need to have a combo box that includes the surnames of customers. When I select a customers surname...