Christine Pearc
Christine
- Local time
- Today, 15:39
- Joined
- May 13, 2004
- Messages
- 111
The OnClick event for a cmdbutton sends a report to a SNP file. Whilst this is happening, Access displays a message that says "Now outputting... <file name and path>. I don't want this message to display, especially since there is a Cancel button on it!
How can this message be suppressed? I've tried this:
DoCmd.SetWarnings False
DoCmd.OutputTo acReport, "rpt New Employee",
acFormatSNP, "Z:\HR\Admin\NewEmp.snp", False
DoCmd.RunMacro "SendMail"
DoCmd.SetWarnings True
Cheers,
Christine
How can this message be suppressed? I've tried this:
DoCmd.SetWarnings False
DoCmd.OutputTo acReport, "rpt New Employee",
acFormatSNP, "Z:\HR\Admin\NewEmp.snp", False
DoCmd.RunMacro "SendMail"
DoCmd.SetWarnings True
Cheers,
Christine