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
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