Printing Report

J

jeff

I have worked out the printing options. Thanks to Fred.
Now when the option is taken to print out the pages, even when I CANCEL the
command still goes through. I want to have the option that if I cancel that
the page will not print.
Thanks.
=============================================
This is the code:
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.SelectObject acReport, "ReportName", False
DoCmd.PrintOut acPrintAll, , , , InputBox("How Many copies?", ,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with printing multiple copies of a report 0
Problem with printing a word document containing a table 0
Passing OrderBy criteria from Form to Report 1
passing OrderBy criteria from Form to Report in accde file 1
Print all Tabs of a Report Created from a Form 1
Page numbering with Merged Document and IF statements 1
Button Help - Print Multiple Reports 1
Access prints form instead of report!! 4

Top