Sending Printer commands

[Tony]

I have a barcode printer that is NOT the default printer. I can
programmatically send a report to this printer using VBA and the Printers
collection. The problem is that I cannot set the report's printer properties
to "Use Specific Printer" since my users may have different barcode printers.
It has to be set to "Default Printer".

When I go to print a barcode, it will print from the correct printer, but it
is using the printer settings of whatever the default printer is. If I set
the reports printer settings to "Use Specific Printer" and set the barcode
printer, it prints using the barcode printer's settings.

How can I fix this so the correct paper settings are sent to the printer
without setting that printer as the report's specific printer?
--Tony--

 

[Alex Dybenko]

Hi,
have a look here:
http://www.mvps.org/access/reports/rpt0009.htm

"Download the code (DefaultPrt.zip) from here (Courtesy of Ken Getz)."


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Tony]

Alex,

thanks for the link, but most of this talks about changing the default
printer, which I already know how to do. I need to change the printer's
specs so the NEW default printer doesn't use the page layout of the old
default printer.... this is what's happening now.

 

[Alex Dybenko]

Hi,
Perhaps I do not understand you, but mentioned code changes default printer
before printing of the report and then restore old default

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com