Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Reports: Printout Multiple copies of a report

Author(s)
Dev Ashish

(Q) How do I printout multiple copies of one report without having to use the Docmd.OpenReport multiple times?

(A) Use the Printout Method of the Docmd object.

        DoCmd.PrintOut [printrange][, pagefrom, pageto] _
            [, printquality][, copies][, collatecopies]

For example, if I want to print out two copies of the first page of a report, I would use
DoCmd.OpenReport "rptCustomers", acViewPreview
DoCmd.PrintOut acPages, 1, 1, , 2

'Access 2.0 equivalent is Docmd Print

OR as posted by Alex Dybenko, the following method which does not require the report to be in Preview mode.

DoCmd.SelectObject acReport, "rptCustomers", True
'This prints out two copies of the report
DoCmd.PrintOut , , , , 2
'Access 2.0 equivalent is Docmd Print 


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer