Alex & Access

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
My Photo
Name:Alex Dybenko

Location:Moscow, Russia
Google
 
Web AccessBlog.net

Friday, October 26, 2007

How to print several copies of report

There is no option to specify number of copies when you run DoCmd.OpenReport. But still there is a way to do so:

DoCmd.SelectObject acReport, "MyReport", True
DoCmd.PrintOut acPrintAll, , , , intCopies

Where intCopies specifies the number of copies. Using DoCmd.PrintOut you also get access to other options of Access Print Dialog – Print range, pages from-to, etc.

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home