Feb 22, 2003 #1 ryan1 Programmer May 15, 2002 106 US How do i get the Default Print Dialog box to appear so the user and select desired printer before printing.
How do i get the Default Print Dialog box to appear so the user and select desired printer before printing.
Feb 22, 2003 #2 ajdesalvo IS-IT--Management May 1, 2000 334 US In the report's OnOpen event, put this code: Private Sub Report_Open(Cancel As Integer) On Error GoTo Exit_Sub DoCmd.RunCommand acCmdPrint Exit_Sub: End Sub The print dialog box will pop up. Good luck! Anthony J. DeSalvo President - ScottTech Software "Integrating Technology with Business" Upvote 0 Downvote
In the report's OnOpen event, put this code: Private Sub Report_Open(Cancel As Integer) On Error GoTo Exit_Sub DoCmd.RunCommand acCmdPrint Exit_Sub: End Sub The print dialog box will pop up. Good luck! Anthony J. DeSalvo President - ScottTech Software "Integrating Technology with Business"