Recent content by Sisko

Is it possible to run a query, in the format of a form? All I need is a query, in the format of a form which will search a car database on the car registration number and or its make. Now, I know how to set up a query to do this, but what I need to know, is it possible to set it up to run as...

Yeah, i know its random. lol. but i think it saves hassle from having to fiddle around with other things. Say, if I hire a car out on the 15/06/06, and its due back on the 20/06/06, what would you recommend would be a suitible criteria to input into a query to remove/exclude that car as a...

One thing, are you saying then that I will need a query, like an update query in order for this to work?

and that will prevent the system from allowing cars that are already hired, from being "hired" out again?? :)

When a customer wants to take out a car, a car is chosen by its registration number, nothing else. Each car has a hire date, and a due date for when the car is due back. I need my validation to be set up so that, when a car is already hired out, that car registration number is removed from the...

Is there a way to set up validation so that: 1: The system will not allow a car already hired, to be hired out again I have a loans form, but i've noticed that, it lets me hire out any car, even cars that are already hired out. any tips on how to set up the correct validation? cheers guys

Ok, I have created a basic form layout for a main menu. I have various text boxes drawn up offering options, such as, add a car to the database, add customer to the database, query cars etc I've been told that I can then link these text boxes to their correct tables, but I don't know how to do...

Hello all, i'm trying to create a database just now and i'm banging my head a little on the forms side of things. Can anyone tell me how, or if its possible, to create a "Main Menu" form, that gives you options to say, add a record to a table, to delete a record etc. any help would be greatly...