[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/> 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Swisher,
Timothy B.
Sent: 10 April 2003 17:17
To: accessd at databaseadvisors.com
Subject: [AccessD] Print to PDF through code




Hello group, how can I programmatically print to a .pdf without changing
default printers and all that.  I want to be able to supply a file name
through code and have that report be saved as a .pdf.  I think I saw
something in the Archives, but since Drew burnt his neighborhood down, I
can't go back and find them.  Any help is appreciated.  Thanks.

Tim 

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