I have the following code that saves to PDF and saves (on my Computer) directly to my Desktop without a SaveTo/SaveAs Dialog
Is there a way to have the Dialog to SaveTo with the Naming convention and AutoStart set to True?
On Error GoTo OutputPDF_Error
strReport = "My_Report"
strFileName = Year([Auto_Date]) & "-" & "My Report" & ".pdf"
DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, strFileName, True
If Err.Number = 2501 Then
'MsgBox "Export was cancelled!"