[AccessD] Change printer

Hi Joe
This crops up regularly on the list. If you search the archives on PDF
you'll find a bunch of hits with lots of advice. And I'd suggest you rename
this thread to put PDF in it somewhere because there are solutions to
creating a PDF which don't involve changing printers, basically by using
3rd-party products to do so, and other listers who know about those products
may not spot the thread otherwise.

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Joseph O'Connell
> Sent: 12 January 2004 16:23
> To: ACCESS-L at PEACH.EASE.LSOFT.COM; AccessD at databaseadvisors.com
> Subject: [AccessD] Change printer
> 
> 
> Cross posted to Access-L and AccessD
> 
> I thought this was discussed recently, but I cannot find the 
> solution in the archives.
> 
> Win 2000
> Access 2000
> 
> Is there an easy way to change the output device for a 
> report?  An application has several reports that are normally 
> sent to a specific printer.  Now the client wants the ability 
> to selectively create a PDF using Adobe Distiller and have 
> the PDF sent as an attachment to an email message. Because 
> this procedure must be totally automated, having the print 
> dialog box popup is not a viable solution.
> 
> I know that this could be accomplished by having a second set 
> of reports that are already set to output to Distiller, but 
> this would create a maintenance problem to ensure that any 
> changes made to a printed report are also made to the 
> Distiller report.  What I am looking for is code that can 
> change the destination to Distiller and then change it back 
> to the original destination after the PDF is created.
> 
> Does anyone have the code to to this?  Or can someone point 
> me to the API that can read and set the printer for a specific report?
> 
> Thanks.
> 
> Joe O'Connell
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>