How to print a full page of labels?

[dontay]

The label Wizard alows me to print one particular address label at a time. How can you print a full page of a particular label?

Thanks in advance
Don

 

[dhookom]

I create a table "tblNums" with a single field "Num" that is numeric integer. Add records with values 1 - some large number. You can then add this table to your report's record source query and set the criteria under the Num field to something like:
<=30
This would create 30 times the number of records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CosmoKramer]

faq703-3276

I'm CosmoKramer, and I approve this message.

 

[67peshawar294]

Hey Cosmo, haven't seen you around for awhile...
been using your little trick and giving you credit whenever I use it...
jim

 

[ProgramError]

My I mention that the record source of the report needs to contain this query.
I tried creating the labels using
docmd.openreport method and found it would ask me to input the 'tblnums.field' !!! the query itself produced the correct results, but for the life of me I couldn't get it to show the correct results on the report unless i put the query in the record source. The results were either all records showing x number of copies of the label I wanted or only one copy of the label.

Ian Mayor (UK)


Program Error
Programmers do it one finger at a time!