Search results for query: *

Title: Access 2002 Desktop Developer's Handbook Authors: Paul Litwin, Ken Getz, Mike Gunderloy Publisher: Sybex

Have a look at the thread "Keyword Search" in Access Forms Forum commenced Sep 17 2002 for some ideas which may help

It sounds as if an "Update Query" could satisfy your needs

" 4. All the 5 Tables are NOT related with each other so I cannot JOIN. " end quote

I'm watching this thread with great interest because whilst I've read that you can base a report on multiple queries I've never worked out how. In the past I have worked around this using a number of sub-reports on the main report ( 1 sub for each query). Maybe that is the only way!

To answer your first question you need to base the report on a query (not on the table) and put the criteria for which records you want to view in the query. Same would work for the ID numbers. But is it only when you PRINT that you want to limit the ID nbrs or in PREVIEW also?

Thanks Daniel - Just what I needed; it works a treat!!

In Access 2002 (and possibly earlier) "Compact and Repair data base" will reset autonumber to start at 1 (Assuming the table is empty)

I remember having such a problem - I'm pretty sure the only way I could resolve it was to change the screen resolution under which I was designing the data base. I know it sounds silly but have a play around with screen resolution and see how you go.

Thanks for trying but no. This is a log and I need to keep page numbers sequential with latest date/time on the last page.

How can I open a Report in Preview at the last page, please?

I have a macro which runs a number of queries which make/append to a table. The macro runs on the OnOpen Event of a sub-report; the sub-report control source is the table. If I open the main report in preview mode and then click the PRINT icon I get the following error: "The database engine...