Avatar of SteveL13
SteveL13
Flag for United States of America asked on

Make report print to a default printer

I'm using this code to printer a report.  But I don't want the user to have to select the printer.  Just print to his/her default printer.  How can this be done?

Here's my current code:

    DoCmd.OpenReport "rptInboundRecord", acViewPreview, , "[ID]=" & Me.txtID, acHidden
    DoCmd.RunCommand acCmdPrint
    DoCmd.Close acReport, "rptInboundRecord", acSaveNo

Open in new window

Microsoft Access

Avatar of undefined
Last Comment
SteveL13

8/22/2022 - Mon
PatHartman

If you define a default printer on your system and create the report to print to that, it will also print to the default printer for your client.
SteveL13

ASKER
Pat, I have my printer set as the default in my system.  And in the design of the report I have it set to Default Printer.  But I still get the widow to select a printer when I click print.  Maybe that is how it is supposed to work?
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SteveL13

ASKER
Perfect.  Thanks.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23