I am trying to print some reports through vb
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?
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?