Trying to print only reports

Prayder

Registered User.
Local time
Today, 04:29
Joined
Mar 20, 2013
Messages
303
I am trying to print some reports through vb

Code:
Private Sub Command173_Click()
    DoCmd.OpenReport "Daily Production Rpt -1st shift", acViewNormal
    DoCmd.PrintOut
    DoCmd.Close acReport, "Daily Production Rpt -1st shift", acSaveNo
    DoCmd.OpenReport "Daily Production Rpt -2nd shift", acViewNormal
    DoCmd.PrintOut
    DoCmd.Close acReport, "Daily Production Rpt -2nd shift", acSaveNo
    DoCmd.OpenReport "Daily Production Rpt -3rd shift", acViewNormal
    DoCmd.PrintOut
    DoCmd.Close acReport, "Daily Production Rpt -3rd shift", acSaveNo
End Sub

between each report that runs and prints it also prints the switchboard page that the actual print button is on. How can I get this to stop?
 
I didnt realize that the
Code:
DoCmd.OpenReport "Daily Production Rpt -1st shift", acViewNormal

would actually open and print the report at the same time. Answered my own question.. How cool is that?
 

Users who are viewing this thread

Back
Top Bottom