<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=100043020-10042003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=100043020-10042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><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> 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>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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></FONT></P></BLOCKQUOTE></BODY></HTML>