Search results

Hi, I'm building a small-ish database that needs to keep track of cars that are being booked out for rental. The cars are obviously in a separate table so you can add and delete cars from the database as you want but my problem comes when booking the rentals. I have two dates - date the car...

At the moment i have a refresh button which the user has to click before clicking another button to open a different form. Is there a way of adding a refresh function to the other button so it refreshes the form before opening the new one???? Thanks a lot, Neil.

I have a form based on a query that has data from one table. On the form there is a subform which uses data from a related table (one to many relationship). My problem is: When a record is entered into the form, you have to enter a record into the subform as well or it will not show up next time...

On my all forms in access 2000, if you tab through all the fields and past the last one, it leads you on to a new one. Is it possible to stop this so that when you tab out of the last field it just puts you back to the first field of the same record?

I have a search form which uses queries to open a form so it is filtered accoring to the users input. However, when no matches are found it just opens a blank form. Is it possible to make it display a message box instead? Saying that no matches are found. Thanks.

Ok this is really annoying me. I set all my reports to landscape, size A4. But for some unknown reason they always, without fail revert back to letter sized paper which pushes the reports across 2 pages. Occassionally they revert back to portrait as well. Why do they do this and can i stop it?

This is a big problem for me. I have a report which is created by a query. However, i need the user to be able to specify which records are shown - monthly. E.g. the user will say whether she wants all of april's records or all of March's records etc. However, the field i need to use for this...

Can anybody tell me the syntax in a delete query where i want to delete all records that have the date in one field older than 6 months. Thanks a lot.

What i want is that when a particular field on a form is exited (i.e. you tab out or select another field with the mouse), then the first record is entered automatically into the subform. This automatic record will be the same value every time. Is this possible?

I want to append dta from one database to another. This is straight forward enough if i want to append just opne table of data. However, the database has 4 related tables and i would like to append related records from each of the tables according to criteria of one field in one of the tables...

I have a form that takes data from a query, within this form there is a subform that takes data from a separate table. My problem is, when an entry is made into the form, unless an entry is also made in the subform, then the record will not show up next time i open the form. Is there a way to...

I need a currency field in a form to equal the sum of all entries in a subform. Is it possible to automate this or will the user have to work this out and type it manually? (By the way this is in Access 2000) [This message has been edited by Neilw (edited 03-13-2002).]