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

[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

 

[Allan Murphy]

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

 

[Guest]

Go to VBA Help and read up on the PrtDevMode Property.