Error 2024

[Bob Barnes]

There is an older answer in the "Archives" here, but that didn't work for...

F, 3/7/08 - Error 2024 - "The report snapshot was not created because you
don't have enough free disk space for temporary work files."

The Code is...DoCmd.OutputTo acOutputReport, "BudgetSheet", _
"Snapshot Format", "C:\BobDev\S" & Format(Now(), "mm/dd/yy") & ".snp", False

TIA - Bob

 

[Tom Wickerath]

Hi Bob,

This part of your expression, which you can test in the Immediate Window,
results in illegal characters (forward slash) in your output filename:

?Format(Now(), "mm/dd/yy")
03/08/08

Try something like this, instead:
Format(Now(), "mm_dd_yy")

or, perhaps better yet, something like this:
Format(Now(), "yyyy_dd_mmm")


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Bob Barnes]

Tom..

I used Format(Now(), "mm_dd_yy"),
and it WORKED !!!

Thank you - Bob

 

[Tom Wickerath]

You're welcome.

I would have been quite surprised if you had reported that it did not work,
because I tested it first before posting my reply. This included creating a
folder off my root drive named "BobDev", and copying an existing report in
Northwind, giving it the name "BudgetSheet". <smile>


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________