تفضل
ضع الكود في اي مكان داخل محرر الأكواد
Sub ExortPDF(ReportName As String, FldrName As String, NewFileName As String)
On Error GoTo ErrH
Dim fso As Object, FldrPath As String: Set fso = CreateObject("scripting.filesystemobject")
FldrPath = CurrentProject.Path & "\" & FldrName
If Not fso.FolderExists(FldrPath) Then: fso.createfolder (FldrPath)
DoCmd.OutputTo acOutputReport, ReportName, _
"PDF", FldrPath & "\" & NewFileName & ".pdf", _
False, "", , acExportQualityPrint
Exit Sub
ErrH:
MsgBox "Opes Erorr" & vbNewLine & vbNewLine & "Eror Number :" & " ( " & Err.Number & " )" & vbNewLine _
& vbNewLine & "Eror Description :" & vbNewLine & _
Err.Description, vbCritical + vbOKOnly, "Err"
End Sub
و في ازرار الحفظ ضع الكود التالي
Call ExortPDF("فاتورة", "BillsFolder", Format(Now, "yyyy-mm-dd"))
سيتم انشاء مجلد و سيتم حفظ الفواتير بتاريخ اليوم الحالي