Code to change DYMO printer
Posted on 2014-09-07
I see "Beehilly" was struggling with this, but it did not look like it got resolved.
For my Accde on the server... User swapping a DYMO printer might change the Printer Name (Eg. "Dymo 400" to "Dymo 400 Turbo" and when this happens my Accde on the server can not resolve how to change this for 3 reports I have.
I've tried combinations of this.... w/o luck. Any ideas?
DoCmd.OpenReport ReportName, View:=acDesign, WindowMode:=acHidden
Dim prt As Object
Set prt = Application.Printer
Application.Printer = Printers(UseThisPrinterName) ' (e.g. "DYMO Labelwriter 400 turbo")
Set Reports(ReportName).Printer = Application.Printer
I think something like this worked on Server 2003, but now moved things to Server 2008 and no luck.
I sure appreciate any help.