Getting error 2024 on Docmd.OutputTo command

M

mscertified

I'm running the below code and it fails on the docmd.outputto statement with
error 2024 "the report snapshot was not created because you dont have enough
free disk space for temporary work files". I can do the export manually via
the toolbar with no problem. Any ideas?

Dim strPath As String
DoCmd.OpenReport "rptTAD", acViewPreview
Reports("rptTAD").ZoomControl = ReportZoomPercent
DoCmd.OpenReport "rptNotification", acViewPreview
Reports("rptNotification").ZoomControl = ReportZoomPercent
strPath = DLookup("SnpPath", "tblPath", "[SnpType]='TAD'")
If Right$(strPath, 1) <> "\" Then strPath = strPath & "\"
strPath = strPath & gUserID & "\AppID-" & Me!AppID & ".SNP"
DoCmd.OutputTo acOutputReport, "rptNotification", "Snapshot Format",
strPath, True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zoomcontrol property of Reports collection 2
Error 2024 3
Outputting to PDF in A2007 0
Runtime Error 2024 1
VBA Error 2024 : Report Snapshot not created 5
Report Error With No Data 5
Strange problem with DoCmd.OutputTo 2
VB Error 2024 1

Top