Recent content by helpme5

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

Thanks very much for you help David, I greatly appreciate it.

Ok cheers, no worries, just glad for the help!

Thanks a lot David, you've been a real help. Will try out tomorrow. Thanks again.

Hi David, thanks for the reply. I was just wondering - wouldn't the [Next Renewal]-60 just show the custom formatting on the date 60 days before the next renewal, and on no other days after that? Thanks a lot

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

I did that, but for some reason abnormal results appear at the bottom of each list/drop down box as shown below: The 3 appears as vehicle ID with a 3 as registration, and this varies for each record and is not in the query. Any ideas on why it is doing this? Thanks.

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

Sorry, I meant that I need this query to show when there is a vehicle free for any certain day and at a specific time, e.g. 2nd February 2009 between 1am and 3pm. Therefore vehicles that are booked between, say, 9am and 5pm will not appear when the search for the available vehicles would be...

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

ok cheers, it works

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.

Thanks. The problem is though that I do not get that option in the combo box wizard I only get the first two options (or the other two not including that)! I will look into that though!

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