Creating a PDF from an Access 2003 Report

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top