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

Yes! Thats what it was.. I tried requery just before i read your post and it worked.. Wow I was about to give up! THANKS :):):):D

I cant see how that would help.. I created a client list box too but when i create a new client... Say i have last client id on client table 35 and i add a new client and save... The client is created with client id 36... But on the form in the list box, the client id 36 does not appear... It...

Ok.. so I have created a new field with two selections "New Customer" and "Existing Customer". If one selects existing customer the user enters a value in customer_id field and all the info appears on the screen with dlookup. When a user enters a new customer the customer_id field automatically...

Yes, I will make an append query which will add new clients in the clients table when clicking on the save button after adding the rental details. If I enter a Client ID in the Client ID field it requires me to have an existing client ID in the clients table. All I want to know is how to be...

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

Great! It works now!! Thanks so much guys ������

Ok... I think im getting somewhere now... I have made a query to Find out the cars hired out within a date range... The query SQL is as follows: for understanding - matricula means number plate, fecha entrega means date of delivery and fecha devolucion means date back SELECT...

Ok so I wrote it in English for simplicity but my actual database is in Spanish, but this wont change anything... My table for reservations is "Reservas", Fields involved in this are num_reserva ( reservation number ), matricula (number plate), fecha_reserva (reservation date), fecha_recogida...

Yes, ive tried that and It keeps giving me errors saying the table which im referring to does not exist when it does... Does anyone have an example database of a dvd store or library where it prevents duplicate bookings??? Ive been trying for dsys and cant get it to work :(

Hello! the file won't open :mad::mad::banghead:

Thanks but i think that doesnt answer my problem. Couldnt i use a condition with iif?? Something like iif num_plate between dateout and datein = 1 Then msgbox ("car is already hired for these dates") Could someone help with the coding as i am pretty new with sql! Thanks

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