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
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