Suppress display when outputting to a Snapshot file

  • Thread starter Thread starter mc
  • Start date Start date
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
 
Back
Top