Outputto Report

[Humberto]

Hello, I'm trying to export a report with OUTPUTTO function with a VB but it gives me an error that goes like this:.

Run-tim error '2024': The report snapshot was not created because you don't have enough free disk space for temporary work files.

This is what I have:
DoCmd.OutputTo acOutputReport, [eomreport], [acFormatSNP], [g:vault\rojas\now()], True

I have more than enough space to run this program.


I also tryed it with a Macro but it gives me the same error.

Can someone Please Help me. Thank you

 

[modest]

This was posted some time ago and I'm not sure what the specific cause is. I did encounter it before and I'm not sure how it was fixed. I believe it's because I used an illegal character in the output name. In my case, I think the file name had a "/".

I'm not positive but now() may return an illegal character in the older Access versions. I know in the newer Access apps return it as MM-DD-YYYY, or whatever is your regional default. Furthermore there may be an error produced in your string by not including the "\" after the "g:".


Again this is a late thread, but no one ever responded.

 

[modest]

Or See:
http://www.access-programmers.co.uk/forums/showthread.php?t=71044&highlight=error+2024

For a better solution