Copies of Access Report

G

Guest

I am trying to print more than one copies of an access report. I tried
Docmd.PrintOut acPrintall,,,,5 --- did not work
Application.Printer.Copies=5 --- did not work
For Next Loop --- it works but does not solve the problem
I am printing labels on thermal printer and if I print it with for next
statement it takes lot of time to print like 150 times, but if I manually set
the number of copies on printer to 150 it goes bam and in few seconds
everything is printed.
I want to set the number of copies on pritner through code, each time
I print the report. How can I do that...????
Help will be appreciated Thanks
 
G

Guest

I would use a loop
For I=1 to 5
docmd.openreport "ReportName"
next I

Or you can use the
docmd.PrintOut acPrintAll,,,,5
After you open the report in preview.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top