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

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.

"Harpreet" wrote:

> 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