Search results

i have all that :) yay i was right!:)

thanks...sorry!

thanks...sorry!

the last part i have :)

for renting out, its per hour * the car each car has a different rent per hour (because they are different cars) I have made a table with the prices and that is joined up to the "Cars" table... but its getting that calculation on the bookings form.... if i add in the form detail, the prices...

driver isnt a customer... a driver is one of the staff... really should be called staff instead :)

last Q i hope :) i am also going to make an ASP.NET page out of this to do online bookings (this isnt for real, just a small project for me) What i need to know is, i need to show the availible dates and times for a particular car availible. my tables: Bookings Cars Drivers Customers should...

i cant view my form in proper mode now!!! nothing is there but in design view, there are components there! whats happening?

thanks :) *working on costs field....scratches head* you've been a big help, thanks alot :) cant express my thanks to you enough!

where can i find that?

i really have no idea at the minute. faced another problem however, i added a new field in the bookings table and saved it. but how do i get that field in the form? I created a text box manually for that field but cant see the new field in the control source property of that text box. how do...

sweet :) wish there was a way of making it into a text box, but its cool, i can just disable it :) thanks! what about calculations? :) i have a table of "prices" i have a table of "cars" for each car, different prices per hour i have a field in the bookings table "total bill" and "hours...

that is correct. In the bookings table, there is a driversID field, which is linked to the Drivers table field DriverID The combo box for Drivers ID is from the bookings table, with the Row Source set to the drivers table, so it gets all the driversID from that table - cool! but, i need to...

i am playing with it, its a pain! :) re reading your reply, what exactly do u mean? I have a combo box with a "DriverID" and the data source is the table "drivers", the form is made from the table "bookings" when i select the driver ID from that combo box, i want the text boxes that i have...

sure, thanks very much :) I seem to have sorted it, access did it for me automatically (awesome!) however, in a form, customly made, if i add another field/text box, how can i link it to make it autocomplete if another drop down box in the form can retrieve its data? so when i have selected...

In Access, on a form, when we select lets say a customer ID from a drop down box, is there a way to automatically fill in the fields, like customer name and address based on the ID chosen from the drop down list? if so - how? thanks :)

Hi there I am trying to make a simple "booking" system. This booking system is for cars. We have customers, cars availible and the date and time and location etc... of when to pick up the customer So 4 tables i have so far: cars customers Bookings Drivers a field in Bookings known as...

In MS ACCESS, is there a way to auto increment a pri key field? I can't seem to find it! any ideas?

nvm - sorted

i have this deadline for monday and only got it issued out today!!!!! my collegue/senior had made it almost all working, it was working fine in the office, then i backed it up, sent myself and email with the attachment - and now it gives me the stupid runtime error - something like object wasnt...