You have to acquire software capable of creating PDF files.  Many of these are
free.  Most work by acting as a virtual printer so once installed you can create
PDF files from any program capable of printing.

Hi.

Make your PDF program, such as Acrobat Writer, the default printer and
"print" the report with the following line of code:

   DoCmd.OpenReport "rptMyReport", acViewNormal

If you are using Access 2002 or higher, then you can use code to switch the
default printers.  If you are using an earlier version, check out Albert
Kallal's switch printer code on the following Web page:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If you don't already have Acrobat Writer installed, you could install a free
one, such as CutePDF, and print the report to it.  Please see the following
Web page:

http://www.cutepdf.com/Products/CutePDF/writer.asp

It requries Ghost Writer (link found on that same Web page) and the printer
driver.

Other PDF writers to consider:

http://www.pdf995.com
http://www.primopdf.com
http://sourceforge.net/projects/pdfcreator

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers.  Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

Our products might have some interest to you.

Mark
RPT Software
http://www.rptsoftware.com

PS: If you don't figure out your best solution send me an email (use the
support email from our site)
and I will help you out with possible solutions.  Been selling our products
for about 6 years.

I have Adobe Acrobat v7.0 installed. I used some code to select the correct
printer but am getting the dialog box to save the document. I would like to
specify the document name and path to save it before printing or duing
printing so I don't have this come up. This needs to run w/out any user
intervention.

Any Ideas?
TIA,
Ed

If you want additional information on PDF-related issues, try this link:

http://www.granite.ab.ca/access/pdffiles.htm