Printing problem

[Danielf]

Hi,

I don't know if this is an access problem but since I am only
encountering this problem in access, it could be.

In access, when I am printing a report from within a form with the code :
" DoCmd.OpenReport" ,
the printer begins to print immediately the first report but when I am trying to print 2 or more copies,
the printer stops for more than 1 minute between the two copies.

Does anybody have a solution for this problem?

Thanks

Daniel

 

[DJN]

How are you specifying the number of copies? A complex query will slow things down. Use the Printout Method of the Docmd object.

DoCmd.PrintOut [printrange][, pagefrom, pageto] _
[, printquality][, copies][, collatecopies]

For example, if you want to print out two copies of the first page of a report, you would use
DoCmd.OpenReport "rptCustomers", acViewPreview
DoCmd.PrintOut acPages, 1, 1, , 2

Hope this helps.


David

 

[neileg]

This is a guess, but the printer may be waiting for an end of file marker from the first report, and timing out, before it prints the second.

 

[Danielf]

Hi DJN,

Thanks it works but maybe like neileg is writing: the printer was waiting for an end or file marker from the first report