Christine Pearc
Christine
- Local time
- Today, 19:27
- Joined
- May 13, 2004
- Messages
- 111
I posted this query about suppressing an Access message box 1 year ago but never received a response. I've worked around it, but it has become an issue again. Back then, I was trying to send an SNP file, but I'm having problems with the "not enough disk space message" and haven't had resolution on that issue either, so I'm now trying to work with an RTF output.
Can someone PLEASE look at this for me asap?
The OnClick event for a cmdbutton sends a report to a RTF 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 acOutputReport, "rpt CAR form HTML", acFormatRTF, "M:\Public\CPAS\CAR rec", False
DoCmd.RunMacro "SendMail"
DoCmd.SetWarnings True
Cheers,
Christine
Can someone PLEASE look at this for me asap?
The OnClick event for a cmdbutton sends a report to a RTF 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 acOutputReport, "rpt CAR form HTML", acFormatRTF, "M:\Public\CPAS\CAR rec", False
DoCmd.RunMacro "SendMail"
DoCmd.SetWarnings True
Cheers,
Christine