Report Copies??

[Michael Kintner]

How can I tell a report to print 5 copies?

VB Code Please....

Thank you in advance for any help... (smile)

Mike

 

[Sandy]

Mike,

DoCmd.RunCommand acCmdPrint will bring up the print dialog where you can set
whatever number of copies you want.

 

[Van T. Dinh]

If you use Access 2002 or later, check Access VB Help on
the Property "Copies" of the Printer Object. Code sample
is in the Access Help topic.

For earlier Access version, a fair bit harder (but
possible) since there is no Printer object.

The easy way is as PC Datasheet recommends.

HTH
Van T. Dinh
MVP (Access)

 

[___]

Put the following code in the OnClick event of your print butto
changing "YourReportName" to the name of the report you want to print
times...

Code
-------------------

Dim looptimes, count As Integer

looptimes = 5
For count = 1 To looptimes
DoCmd.OpenReport "YourReportName", acNormal, ""
Next count

 

[Van T. Dinh]

Yes but this means that Access has to process the Report 5 times rather than
1. For some complicated Reports, it adds unnecessary delays.