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

Select Printer

P: n/a
Ian
I have an Access 97 database, on a Report I have the print option set to
print to the PCís default printer rather than a printer selected from
the list.

My question is: Can I allow the user to change this setting so that by
default the report will print to a specific printer that they select
rather than the PCís default printer?

The reason for wanting to do this is that I donít know the names of the
printers they might have and the DB is an MDE so they cant go to design
view and change it themselves.
Mar 17 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I did this once

I think I used a macro to activate the print dialogue box
Then assign the Macro to a tool bar
Then assign the tool bar to the report.

In this way the icon on the tool bar that appears when the report shows call
the print dialogue box rather than just printing the report to the defined
printer.

I expect you can also do the same with code and while macros are old and
clunky they can still solve simple problems in a simple way.

I also added other report related buttons to the button bar such as a close
button that closes the report and reverts to whatever other forms should be
open.

Seemed to work OK as non of the database users complained

Hope this helps

Andrew Hall
"Ian" <ia********@ntlworld.comwrote in message
news:Gk*****************@newsfe2-gui.ntli.net...
I have an Access 97 database, on a Report I have the print option set to
print to the PCís default printer rather than a printer selected from
the list.

My question is: Can I allow the user to change this setting so that by
default the report will print to a specific printer that they select
rather than the PCís default printer?

The reason for wanting to do this is that I donít know the names of the
printers they might have and the DB is an MDE so they cant go to design
view and change it themselves.

Mar 17 '07 #2

P: n/a
Ian
Thanks
>
I already have code that calls the windows dialogue box and allows the user to select a printer. What I want to do is have them just click Print and this one report automatically goes to a specific printer other than the PCís default printer.

Regards


Ian wrote:
I have an Access 97 database, on a Report I have the print option set to
print to the PCís default printer rather than a printer selected from
the list.

My question is: Can I allow the user to change this setting so that by
default the report will print to a specific printer that they select
rather than the PCís default printer?

The reason for wanting to do this is that I donít know the names of the
printers they might have and the DB is an MDE so they cant go to design
view and change it themselves.
Mar 17 '07 #3

P: n/a
If I remember correctly, the printer can only be set at design time. I
think all you can do is allow them to select from the Printer dialog.

Mar 17 '07 #4

P: n/a
You can pop up the standard print dilaog.

DoCmd.RunCommand acCmdPrint

if you *must* prsent a list of printers BEFORE you want to lanuch the
printer, then I have a working sample for a97 here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Mar 17 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.