Report Copies??

M

Michael Kintner

How can I tell a report to print 5 copies?

VB Code Please....

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

Mike
 
S

Sandy

Mike,

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

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
 
V

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.
 
Top