Suppress display when outputting to a Snapshot file

M

mc

Is there a command I can use to suppress the "Printing to...." when I create
a snapshot file? Here is my code:

strReportName = "rpt_Over_Limit"
strSnapshotRpt = "CIRG "
strDate = Format(dt_As_of_Date, "Mmm dd yyyy")
strSQL = "SELECT strDir_Name FROM tblDir WHERE strReport_Type=" & Chr$(34)
strSQL = strSQL & "SNP" & Chr$(34) & ";"
rst.Open strSQL
strDirFileName = rst.Fields(0).Value & "\" & strSnapshotRpt & strDate & ".snp"
DoCmd.OutputTo acOutputReport, strReportName, "Snapshot Format",
strDirFileName, False
 

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

Top