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: Bring up Print Dialog from code

Author(s)
Dev Ashish

(Q) I need to bring up the Print dialog window from code so that the user can select the number of copies to print among other options. How can I do this?

(A) In Access 97, there is a RunCommand constant defined for this purpose.

        DoCmd.RunCommand acCmdPrint

Make sure that you have error handling in place to trap the error (number 2501) that will be generated if the user clicks Cancel. You can also use On Error Resume Next statement.


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