Removing dialog box when outputting to .snp report
Posted on 2007-08-08
When I run the following line of code I get what looks like a dialog box that remains on screen until the report is produced. The box contains information about the report being produced and moves through the report one page at a time showing the current page that it is on. This dialog box looks very much like the dialog box that comes up when printing something. I would like to remove this dialog box when producing this .snp report if possible but do not know how to do this.
DoCmd.OutputTo acReport, "R2", "SnapshotFormat(*.snp)", "c:\R2test.snp", False, ""