By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Specifying a printer in code - Access 2000

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
mathilda <sm***********@yahoo.com> wrote:
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
Nov 13 '05 #2

P: n/a
Thanks, that was just the thing.

On Thu, 09 Sep 2004 03:42:11 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
mathilda <sm***********@yahoo.com> wrote:
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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.