DoCmd.OutPutto file name with Date 1

[WordTechinc]

I want to save the report with date and time to eliminate replace existed report. I am getting a message "The report snapshot was not created because you don't have enough free space for temporary work files."

Here is code;

Dim stDocName As String
Dim stFileName As String
Dim StDate As String

StDate = Now()

stFileName = "c:\NCTAX\Report\PaymentInfomation_RealEstate-" & StDate & ".snp"

stDocName = "rptRETBankRequestPaymentInfo"

DoCmd.OutputTo acReport, stDocName, "Snapshot Format (*.snp)", stFileName

 

[Remou]

Now contains characters that are not valid for file names: 03/02/2010 20:07:14

Try

Format(Now,"yyyymmdd_hhnnss")

http://lessthandot.com