BMDE
Programmer
- Apr 4, 2006
- 11
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
sFileNameSuffix = Format(Date, "yyyymmdd") & ".snp"
sOutputPath = "C:\CompletedReports\"
sOutputFileName = "RptAssignment" & sFileNameSuffix
DoCmd.OutputTo acOutputReport, "RptAssignment", _
acFormatSNP, sOutputPath & sOutputFileName, False