[AccessD] Print to PDF through code

MessageHey speaking of which, has anyone ever tried out this tool just
posted on the MSDN Flash?

Download a Trial Version of LEADTOOLS ePrint Driver Version 3
LEADTOOLS ePrint from LEAD Technology can save and print to over 140 file
formats. New features in version 3 include extended support for setting up
multiple printers, added support for multiple resolutions, and improved
email support. For developers, version 3 includes new support to set global
settings for each printer, new support for control of dialog boxes, and
more.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
  Sent: Thursday, 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



    -----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/7f3a4261/attachment-0001.html>