Carolyn Johnson
cjlabs at att.net
Thu Nov 18 21:33:08 CST 2010
I need a method to create pdfs that does not require the installation of any other software or printer -- the database is used by a number of organizations with a variety of computers that changes year to year. And the computers have varying operating systems (XP to Windows 7) and versions of Access (2000 to 2010). Lebans code worked great for me until 2010. And the quality of the pdfs was never an issue. It's interesting that the code still produces a pdf, but a portrait oriented document gets cut off and looks like it's printed in landscape. I would have guessed it wouldn't create a pdf at all. Carolyn Johnson ----- Original Message ----- From: Darryl Collins To: Access Developers discussion and problem solving Sent: Thursday, November 18, 2010 6:41 PM Subject: Re: [AccessD] Automating pdf printer _______________________________________________________________________________________ Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________ The other 'downside' with using Access > snapshot > PDF is the final PDF output is a 2nd generation image. This can result in degraded image quality in my experience - if a detailed and sharp result is required this method is inadequate for the task I have found. A single output to PDF is preferable. Regards Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson Sent: Friday, 19 November 2010 11:29 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Automating pdf printer Stephen Lebans code to create pdfs uses the snapshot format of a report to create the pdf file. Snapshot file format is no longer available in Access 2010 == explains why it doesn't work well in that version. Carolyn Johnson >>> jwcolby at colbyconsulting.com 17-11-2010 21:17 >>> A client wants to print stuff to a pdf and send the email. I would create a report and send it to the printer, then pick up the resulting file and send an email. I know how to do everything except the pdf part in the middle. Is anyone doing this? -- John W. Colby www.ColbyConsulting.com -- 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 _______________________________________________________________________________________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. _______________________________________________________________________________________ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com