ketchu1j
Last Activity: Dec 21 '15, 04:47 PM
Joined: Oct 9 '15
Location:
-
Found the answer on another forum site. The secret was to remove the DoCmd.PrintOut acPrintAll line altogether. It still prints without the printer selection pop-up window showing up and does not print the form where the print function button was clicked. Success!! -
how to stop form from printing when printing a report from form
I have been trying to use a command button in Access to print a report to the default printer without showing the printer selection screen first. I finally got it to do that using the following code that I found from someone else on your site...
...Code:Private Sub Command29_Click() 2. DoCmd.OpenReport "rpt_stamp_label", acViewNormal, , , acHidden 3. DoCmd.PrintOut acPrintAll 4. DoCmd.Close
-
printing Access report without seeing report first
I have been trying to use a command button in Access to print a report to the default printer without showing the printer selection screen first. I finally got it to do that using the following code that I found from someone else on your site...
...Code:Private Sub Command29_Click() DoCmd.OpenReport "rpt_stamp_label", acViewNormal, , , acHidden DoCmd.PrintOut acPrintAll DoCmd.Close acReport, "rpt_stamp_label"
No activity results to display
Leave a comment: