print only selected records or send selected records to a temp db?

[sdavid74]

Is it possible to set up a temp. database with the fields from my main db without rebuilding the db? Or is it possible to send selected records to a temp db?

If so, can I use the same reports that I use with the main database?

The reason is that I need to print about 200 labels, but I know I will reeeive more registrants for my program and then need to print theirs as well. Is there a simple way to print just their records to a report? My report is printing out onto an 8.5x11 sheet of 3x4 labels. Anyhelp would be great.

 

[Rolliee]

Add a Y/N box to your record and check it for the ones you wish to print. Then a query where Y/N value is true will print only the check marks.
Rollie@bwsys.net

 

[sko]

How are you selecting the records that need labels? If you can create a query that isolates these records, then you can base the report on that query. No need for a separate database.

For example if you have a registration date you might use that in a parameter query. Prompt the user for a registration date or a date range and run the report.

 

[sdavid74]

Yes, these labels are based on a query. How do I make the query prompt for a date range? I'll look around in this forum and in the Access help, but in case I don't find it...

 

[sdavid74]

also in the query the report is based on, there is a field called "printdate" . That is what I want to set use to select records.

 

[sdavid74]

I got it. I found it in the Access help under parameter query, but now the prompts for the beginning and ending dates pop up twice each time. No big problem, but what's up with that? Is that normal? Is there any way I can make it only pop up once?

 

[sko]

hmmm...
Check your spelling.

In the printdate criteria:

Between [Enter Start Date] and [Enter End Date]

In the query parameter (right-click in the upper-pane and choose parameters):

Parameter:[Enter Start Date] DataType: Date/Time
Parameter:[Enter End Date] DataType: Date/Time

If that doesn't do it...
Are you using subqueries?
Is printdate a field in your table?
Post the sql