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

How do I write code to allow user of a runtime distro to select a DEFAULT printer?

P: n/a
MLH
I would like to allow users to set, as an application default, a
specific printer to send reports to. I don't know how to bring up
a list of valid print devices in A97, nor do I know how to reference
any one of them that might be selected.

For instance, if I click Start, Control Panel, Printers and Faxes on
a PC running XP and I see the following:
HP Laser Jet 4200 PCL 6
HP Laser Jet 4200 PCL 5e
HP Laser Jet III
HP PhotoSmart 7350 series
Jaws PDF Creator
PDF995
WinFax (Photo Quality)
WinFax

How do I reference those in A97? I can write the default printer name
to a table (tblUserSetupConfigs) if VBA can use the name to tell XP
what printer to use on each print job. If it were the default windows
printer, none of this would be necessary. But if the user desires the
runtime app's prints to go to another printer - then I'll have to
explain to Access what printer to use - writing code that'll look up
the chosen print device in a table and so on.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Albert Kallal has a utility for setting the printer in earlier versions of
Access. The A97 link is:
http://www.members.shaw.ca/AlbertKal.../printch97.zip

For a more detailed programming description, see this chapter from Ken Getz
et al:
http://msdn.microsoft.com/archive/de...softAccess.asp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthState.net> wrote in message
news:g8********************************@4ax.com...
I would like to allow users to set, as an application default, a
specific printer to send reports to. I don't know how to bring up
a list of valid print devices in A97, nor do I know how to reference
any one of them that might be selected.

For instance, if I click Start, Control Panel, Printers and Faxes on
a PC running XP and I see the following:
HP Laser Jet 4200 PCL 6
HP Laser Jet 4200 PCL 5e
HP Laser Jet III
HP PhotoSmart 7350 series
Jaws PDF Creator
PDF995
WinFax (Photo Quality)
WinFax

How do I reference those in A97? I can write the default printer name
to a table (tblUserSetupConfigs) if VBA can use the name to tell XP
what printer to use on each print job. If it were the default windows
printer, none of this would be necessary. But if the user desires the
runtime app's prints to go to another printer - then I'll have to
explain to Access what printer to use - writing code that'll look up
the chosen print device in a table and so on.

Nov 13 '05 #2

P: n/a
MLH
Thank-you, Allen. That's a nice contribution Albert made.
I like it a lot.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.