Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 11th, 2003, 04:23 PM
Registered User
 
Join Date: Jul 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Printing to a PDF

Basically, does anyone have code that I could use to "easily" print a report to a pdf then e-mail the report.

I have seen methods posted online but have not been able to implement them properly. I was just wondering if anyone had an easy method.

Thanks

H



 
Old September 26th, 2006, 03:01 PM
pjm pjm is offline
Authorized User
 
Join Date: Jul 2006
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The easiest thing I can think of, if you're really married to the idea of using the PDF format, is to get your hands on PDFwriter (which will probably require you to purchase Adobe Acrobat). This installs as a printer driver so that you simply have to select it as your printer to have it output to a file. You might be able to find something similar in the public domain but I wouldn't have that info at my fingertips.

An easier solution (sans PDF) would be to output your report as an RTF file which should be just as universal (most word processors will open this without a problem).

-Phil-
 
Old September 26th, 2006, 03:34 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have been using an inexpensive third party application called PDF995. It also installs as a printer driver. The good news is that it sells for $9.95 - hence the name. See www.pdf995.com for further information.

Rand
 
Old September 29th, 2006, 10:46 PM
Authorized User
 
Join Date: Jul 2004
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can use CutePDF as a writer (http://www.cutepdf.com/Products/CutePDF/writer.asp)






Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in printing pdf ashish.khare ASP.NET 2.0 Professional 0 August 31st, 2007 09:44 AM
Urgent help with printing and PDF creation mike_remember ASP.NET 1.0 and 1.1 Professional 0 October 22nd, 2005 08:25 AM
Printing reports in pdf format keshavan01 Access VBA 5 January 27th, 2005 12:21 PM
Server side PDF printing mjadhav General .NET 0 May 11th, 2004 07:05 PM
PDF Printing matt.fields Crystal Reports 0 April 30th, 2004 10:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.