I want the built in Save As dialog to be used for the export, however I want to set the default file name as well. I cannot seem to do both at once...
strFileName = A predefined File Name with no Path set. "Default Title for the Export" & strRecordID "Date" and "Logged On User" & ".pdf"
Not an issue here.. works fine
With the following code, the file is exported to the last location where I saved a file. No prompt
DoCmd.OutputTo acOutputReport, , acFormatPDF, strFileName, False, , , acExportQualityScreen
With the following code, the Save As Dialog opens but I obviously do not have a custom / default file name...
DoCmd.OutputTo acOutputReport, , acFormatPDF, , False, , , acExportQualityScreen
If I set any default path to use in lieu of a wild card, then I do not get the Save As with the Autostart check box
I've reviewed the many of the options in online threads but none seem to leave it up to Windows for the Save As dialog...
How do I set a default file name / prompt for a save location meanwhile using the Windows built in Output To dialog box (with the AutoStart checkbox)
Or even better, have the the Publish as PDF or XPS dialog box that you get when manually exporting a report to PDF. (with the 'Open File after Publishing and optimization check boxes)