choosing a specific printer for reports 2

DaveTappenden · Jun 10, 2003

I am using Access 2000 and need a dialog box to allow users to redirect reports to a specific printer.
I have had a look at using the prtdevnames/prtdevmode property, but I think I'm right in saying that these won't work with my MDE application, as the report has to be opened in design mode to make any changes to the prtdevmode property of the report.
I guess I am looking for a way to remember the user's default printer, then change it based on a selection (eg from a combo box), print report to the (new) default printer and finally reset the default printer back to the original settings.

Any help or useful pointers most appreciated.

EliseFreedman · Jun 11, 2003

You could try using
DoCmd.RunCommand acCmdPrint
This will bring up the printer dialog box from which the user can select which printer they require

HTH

Elise

NewCoder2 · May 3, 2004

Elise,
Does this then change the default printer for the pc?
Thanks

EliseFreedman · May 6, 2004

It changes the printer just for that report.

mtompkins · May 7, 2004

Ok - I have a similar issue I'd like to address -

I currently pass a filtered query to a report for printing using:

DoCmd.OpenReport rptNameStr, rptType, , rptSQL

where rptNameStr is the name of the report
rptType is preview / print
rptSQL is the query filter

is there any method to incorporate these into your

DoCmd.RunCommand acCmdPrint

Kindest,
Mark Tompkins

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

choosing a specific printer for reports 2

DaveTappenden

Programmer

EliseFreedman

Programmer

NewCoder2

Programmer

EliseFreedman

Programmer

mtompkins

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor