Search results

Hi. I want to autofill in a text box with reference to a table I have in Access. I have the first text box that returns the first record in the table i want to get the data for with "text1 = Dlookup("numplate", "cars", "") This returns the first record. I want the second text...

Hi, I have a form for rentals where I have fields for car details and for client details. I have a list box for clients so that when I enter the Client Id I automatically get all the records filled out on the form, from the clients table... This works but the problem is that sometimes I have a...

Hi, I'm currently having a problem with my car hire database in access. I want to avoid duplicate booking for the same car number plate between dates, and I don't know how to! The 2 tables involved in this are reservations and cars. The cars table has: num_plate make model colour engine And...