<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=580300118-10042003><FONT face=Arial color=#0000ff size=2>Hey
speaking of which, has anyone ever tried out this tool just posted on the MSDN
Flash?</FONT></SPAN></DIV>
<DIV><SPAN class=580300118-10042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580300118-10042003><A
href="http://go.microsoft.com/?linkid=117750"><B><FONT color=#003399>Download a
Trial Version of LEADTOOLS ePrint Driver Version 3</FONT></B></A> <BR>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. </SPAN></DIV>
<DIV><SPAN class=580300118-10042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<P><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Andy
Lacey<BR><B>Sent:</B> Thursday, April 10, 2003 1:21 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Print to PDF
through code<BR><BR></FONT></DIV>
<DIV><SPAN class=150340317-10042003><FONT face=Arial color=#0000ff
size=2>Tim</FONT></SPAN></DIV>
<DIV><SPAN class=150340317-10042003><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=150340317-10042003><FONT face=Arial color=#0000ff size=2>Or
you can use a 3rd party pdf creator, which others can tell you
about.</FONT></SPAN></DIV>
<DIV><SPAN class=150340317-10042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=150340317-10042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Swisher,
Timothy B.<BR><B>Sent:</B> 10 April 2003 17:17<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Print to PDF
through code<BR><BR></FONT></DIV><BR>
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>Tim</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>