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

Sorted, thanks colin, i used [forms].[frmOrder].refresh. I put that code in before the open form function and its all sorted now. Cheers, Neil.

Any help here please??? Neil.

OK this is the problem, when you open a form and make changes, then without closing that one, open another form and make changes, then when you try to close both forms you are given the option to save only one set of the changes you made. So far my user is having to click a refresh button on the...

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.

Would anyone consider taking a copy of my database to try and figure it out and then let me know? Thanks, Neil.

Thats how it is joined anyway. The subform table is in the query and i have tried taking it out before but it doesn't solve the problem. Any other suggestions? Thanks anyway DBL.

Don't see any problems there. Any other suggestions? I'm getting desparate now, i'm supposed to be installing this for the user tomorrow! Thanks.

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?

Thanks geoff, problem then is that when the form is opened for the first time to put the first record in, it will give the message and close!

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?

Oh no dont worry i got it working! I stupidly didn't realise to change OrderDate to the actual field name!

Nope sorry it doesn't work. Raskew, i've put your suggested code in but there are 2 problems. Firstly, it asks twice for you to put the date in. Is there a way to have it only ask once? And secondly, It doesn't actually do what it's told. I put in 3 records, only one of which should have...

Oh wow i got it working, i just had to paste the code from the brackets onwards into the criteria section. Thanks a lot everyone, Neil.

Ok i looked in Access and i cant find northwind anywhere. Can anyone help me? Do i need to download it from somewhere? I looked on microsoft.com but i couldn't find it. Thanks in advance, Neil.

thanks, i'll try it and let you know

thanks raskew thats great but i dont understand what you mean by "using northwind". Do i just paste all that syntax into the criteria part of the query? And by the way, you're right, it would be better to search by month and year!

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