[AccessD] How to Change Default Printer via Access 2007 VBA Code

James and Stuart,

Thanks for the assistance, I appreciate it.

Learned some new tricks today and now have a user who is all smiles.

Doesn't get much better than that.

Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, March 05, 2014 3:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Change Default Printer via Access 2007 VBA
Code

If it has to be printed on a specfic printer, why not just configure the
report to use that printer.

(Report Design Tools - Page setup - Page - Use specific Printer)

--
Stuart

On 5 Mar 2014 at 15:02, Brad Marks wrote:

> All,
> 
> We have a report that needs to be printed on a specific printer (let's

> call it Printer-B).
> 
> One of our key users has her default printer set to Printer-A.
> 
> Is it possible to temporarily change her default printer to Printer-B 
> for the printing of a specific report and then change the default 
> printer back to Printer-A after the report is printed?
> 
> Thanks,
> Brad
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam. 
http://h0stname/cgi-bin/learn-msg.cgi?id=2C5D628E34.C81FF