<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<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></BODY></HTML>