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
VB Code Please....
Thank you in advance for any help... (smile)
Mike
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandy
Mike,
DoCmd.RunCommand acCmdPrint will bring up the print dialog where you can set
whatever number of copies you want.
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)
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
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.
1. For some complicated Reports, it adds unnecessary delays.