Creating a PDF from an Access 2003 Report

[HighlanderMom]

HI,

I have a report in an Access 2003 database that I need to print as a PDF. I
am using Acrobat Professional 7. What I have so far does most of it fairly
well.

I have set the reports default printer to Adobe PDF (the standard printer
installed for Acrobat).

I have code that does print the report correctly (see code below).

What I need now is
A: A way to force it to accept the default path and name.
B: A way to set it so that newly created PDF does not open.

Existing Code:
DoCmd.OpenReport "rpt_Complaint_EmailPDF", acViewPreview
DoCmd.PrintOut (acPrintAll)
DoCmd.Close acReport, "rpt_Complaint_EmailPDF", acSaveNo
(Yes, its simple, but it works..)

If I need completely new code, I will happily change it.
All help is appreciated.

Thanks,
Connie

 

[Douglas J. Steele]

Take a look at the free Report to PDF utility Stephen Lebans has at
http://www.lebans.com/reporttopdf.htm

 

[HighlanderMom]

Cool, I figured out how to add that code to my database and it works great!

Thanks! :0)
--
HighlanderMom
"You should be careful what you wish for or you may get it."

Take a look at the free Report to PDF utility Stephen Lebans has at
http://www.lebans.com/reporttopdf.htm