How to choose a printer for each report

[sys00]

welcome

I have a report that I print on the printer (HP Color LaserJet Pro M252dw) and a report that I print on the printer (Zebra GK420t - ZPL)
How do I print each report on a dedicated printer without changing the default printer ?

thank you

 

[theDBguy]

Go to Design View of each report and assign a specific printer to them.

 

[sys00]

Thank you

Is there a code to save the name of the report and the printer assigned to print the report ?

 

[isladogs]

This info is taken from: MS Access – Select a Printer | DEVelopers HUT (devhut.net)
You can use code like this:

Dim strDefaultPrinter  as string

' get current default printer.
strDefaultPrinter = Application.Printer.DeviceName

' switch to printer of your choice:
Set Application.Printer = Application.Printers("HP LaserJet Series II")

'do whatever....print reports

'Switch back to default.
Set Application.Printer = Application.Printers(strDefaultPrinter)

OR see Printer Selection Utility (allenbrowne.com)

 

[sys00]

Thank you