Christine Pearc
Christine
- Local time
- Today, 21:44
- Joined
- May 13, 2004
- Messages
- 111
Not sure why nobody is responding to this question, but I've been trying to find an answer since my post of 11 October and a previous one 1 year ago. I'm REALLY desparate for a solution -- there MUST be a cure!!
The problem is that, when you do a "DoCmd.OutputTo acOutputReport", the message "Now outputting... <file name and path>. I don't want this message to display, especially since there is a Cancel button on it!
Try as I will, I can't get people to stop pressing the da&!^% Cancel button (cheeky prats), which when pressed results in a blank report being sent with the email...and then the complaints come in about problems with the code...sigh!
DoCmd.SetWarnings False doesn't work. Also tried creating another form with a Timer event (found on the web to deal with the problem), but that doesn't work either as they still have time to press Cancel.
At wits end,
Christine

The problem is that, when you do a "DoCmd.OutputTo acOutputReport", the message "Now outputting... <file name and path>. I don't want this message to display, especially since there is a Cancel button on it!
Try as I will, I can't get people to stop pressing the da&!^% Cancel button (cheeky prats), which when pressed results in a blank report being sent with the email...and then the complaints come in about problems with the code...sigh!
DoCmd.SetWarnings False doesn't work. Also tried creating another form with a Timer event (found on the web to deal with the problem), but that doesn't work either as they still have time to press Cancel.
At wits end,
Christine