Setting the "number of copies" in code for an access report

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I am running an Access report within my Access 2000 app using the
"docmd.OpenReport" syntax. How can I default the number of copies to print
to three instead of one?

I have tried the docmd.PrintOut method but it is not working... Is there
another way to do this? (See code I used below...)

Thanks,

Brad


DoCmd.OpenReport "rptWarranty_CDA", acViewPreview
DoCmd.PrintOut acPrintAll, , , , 3
 
I use a form where the user can email, print preview or print a report.

To print a report the user enters the number of copies in the field called,
num_copies, clicks on the print button to print the number of copies.

I use a for loop

Dim copies_num As Integer

For copies_num = 1 To Me!num_copies
DoCmd.OpenReport "report name", acNormal
Next
 
Back
Top