Print dialog box in VBA

  • Thread starter Thread starter chad
  • Start date Start date
Where do I insert this? I have the code so far...

Dim stDocName As String

stDocName = "Report 1"
DoCmd.OpenReport "Report 1", acViewNormal
So where do I put the DoCmd.RunCommand acCmdPrint. If I
put it before or after, it gives me an error....

Thanks for the help so far
 
Open the report in preview mode first

Dim stDocName As String
stDocName = "Report 1"
DoCmd.OpenReport "Report 1", acViewPreview
On Error Resume Next '2501 error occurs when you hit cancel
DoCmd.RunCommand acCmdPrint
 
One last question
I have about 19 reports to print, and I was trying to set
it up so that they all printed off one button. Is there
anyway to set the print setting without previewing each
report.
 

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

Print Dialog Box 1
Print dialog box with Page Range selection option with VBA? 2
Access Choosing Printer VBA Access 0
Code help 2
Access prints form instead of report!! 4
Change the capiton of the Report 1
Not sure if report is closed 2
Printing 4

Back
Top