choosing a specific printer for reports 2

[DaveTappenden]

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]

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]

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

 

[EliseFreedman]

It changes the printer just for that report.

 

[mtompkins]

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