Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need more help with Report output to PDF

Status
Not open for further replies.

BMDE

Programmer
Apr 4, 2006
11
0
0
I set the report's printer in Page Setup dialog to the "Adobe PDF" as suggested (great suggestion thanks) and can output without changing the printer default setting in Access. I did not need to write code to select Adobe. Now I need to date the report and output it to a folder. Below is code to output to snapshot. Can someone suggest an alternative to "DoCmd.OutputTo" or Opening the report --this invokes the dialog so that is not what I need. My goal is to automate outputting the report to a folder.

sFileNameSuffix = Format(Date, "yyyymmdd") & ".snp"
sOutputPath = "C:\CompletedReports\"

sOutputFileName = "RptAssignment" & sFileNameSuffix
DoCmd.OutputTo acOutputReport, "RptAssignment", _
acFormatSNP, sOutputPath & sOutputFileName, False

 
I've resolved my issue. In Access's Page setup options, Adobe PDF print propeprties enables supressing the file dialogs when you deselect veiw results and specify an output directory.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top