Hi everyone,
I am creating a report with a consecutive name and also want to include the time like HHMMSS but it doesn't work and just shows the format as 000000
What Do I change to my code on this part?
Code:
Private Sub ExportarPdfcmd_Click()
Dim stDocName As String
Dim stFileName As String
stDocName = "Report_Rpt"
stFileName = "Report of Open Actions "
'What should be changed on my format?
DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, stFileName & Format(Date, "YYYYMMDD-HHMMSS") & " - " & Me.UserNamelbl.Caption, True
MsgBox "Report", vbInformation, "Testing"
End Sub
Thanks for the help!!