[AccessD] Print to PDF through code

I use a terrific product called PDFMail Pro edition (I upgraded to Pro after
a year's success with the Standard edition), from Attac Consulting. It's two
products in one, as its name implies. You can create a PDF from any report,
then email it to anyone(s). The Pro edition lets you add multiple documents
to a single PDF, which was the reason I upgraded. At ETS we had the need to
email a customer about 5 documents, each produced by a different Access
report. Now the users click one button and it all happens. That's my
definition of cool software :-) And I got the glory, though I had to write
only about 20 lines of code.
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: April 10, 2003 1:21 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Print to PDF through code



Tim
Which version of Access are you using? If A97 it's difficult because you
have to change printers interactively to either the Acrobat Distiller or
PdfWriter and that's no joke. I've no experience of doing this in later
versions so I can't comment on them. Apart from doing that it's fairly
straightforward. If you choose to use PDFWriter there's an INI file into
which you can put the name of the file you wish to use. But PDFWriter is old
technology for Adobe and, I believe, being phased out. There preferred
method now is Distiller. With that you have to set Distiller to not request
filenames interactively (a check box in the Distiller printer's properties)
in which case it writes the filename as the report's caption, so watch out
that you don't have characters like / or \ in the caption as it fails
because it's an invalid filename. If you want to determine the filename you
can't, but you can let it write its own then rename the file. That's what i
do.
 
Or you can use a 3rd party pdf creator, which others can tell you about.
 
Or IIRC there's a piece of software which you can purchase that will do it
from Access, but again I acn't remember. I'll look it up if you're
interested. But it does cost so no good if you've no budget.

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030410/0d5f525b/attachment-0001.html>