Specifying a printer in code - Access 2000

[mathilda]

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?

[Tony Toews]

Re: Specifying a printer in code - Access 2000

mathilda <smart_aleck72@ yahoo.com> wrote:
[color=blue]
>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?[/color]

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

[mathilda]

Re: Specifying a printer in code - Access 2000

Thanks, that was just the thing.



On Thu, 09 Sep 2004 03:42:11 GMT, Tony Toews <ttoews@teluspl anet.net>
wrote:
[color=blue]
>mathilda <smart_aleck72@ yahoo.com> wrote:
>[color=green]
>>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?[/color]
>
>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[/color]