Hi Everyone,
1st of all I am new to this site and I would just like to thank everyone who posts and answer posts on here. I am pretty new to MS Access and this site and the users have helped me a lot.
I am having an annoying problem with a print button on a report which seems to always want to print 2 copies everytime the button is pressed.
I have the following code programmed into an 'On Click' event procedure and the problem is present on every PC the database is running on.
Option Compare Database
Private Sub Command12_Click()
DoCmd.RunCommand acCmdPrint
stDocName = "rptMOShortageReport"
DoCmd.OpenReport stDocName, acNormal
End Sub
Any help on where i am going wrong would be gratefully received.
Thanks
Steve
1st of all I am new to this site and I would just like to thank everyone who posts and answer posts on here. I am pretty new to MS Access and this site and the users have helped me a lot.
I am having an annoying problem with a print button on a report which seems to always want to print 2 copies everytime the button is pressed.
I have the following code programmed into an 'On Click' event procedure and the problem is present on every PC the database is running on.
Option Compare Database
Private Sub Command12_Click()
DoCmd.RunCommand acCmdPrint
stDocName = "rptMOShortageReport"
DoCmd.OpenReport stDocName, acNormal
End Sub
Any help on where i am going wrong would be gratefully received.
Thanks
Steve