Specifying a printer in code

Specifying a printer in code - Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mathilda - 09 Sep 2004 01:29 GMT

I am trying to send a report to a specific, non-default printer in
code, bypassing the preview mode, but I cannot find the code to do so
anywhere. Can anybody help?

Reply to this Message

Tony Toews - 09 Sep 2004 04:42 GMT

>I am trying to send a report to a specific, non-default printer in
>code, bypassing the preview mode, but I cannot find the code to do so
>anywhere. Can anybody help?

You can change the default printer using updates to the INI file and some sample
code. See DefaultPRT.ZIP at http://www.mcwtech.com/downloads.htm. This MDB has a
combo box where you select the printer.

Finally you can use DevPrtMode however this requires extensive VBA knowledge and is
not for the faint of heart. Also this won't work in MDEs as you must open reports in
design mode although you can use Automation to open a reports MDB and manipulate it
there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message

mathilda - 10 Sep 2004 00:19 GMT

Thanks, that was just the thing.

>>I am trying to send a report to a specific, non-default printer in
>>code, bypassing the preview mode, but I cannot find the code to do so
[quoted text clipped - 10 lines]
>
>Tony

Reply to this Message