Julie has attended:
Access Advanced course
Access VBA course
Suppress MS Access message
I have a form that people fill in to make a measurement request. When they click a button to save and send the form it sends them an email confirming their job number.
When they click this button Ms Access gives a message box saying "this program is trying to send email - do you want to allow this?" I would like to stop this message being shown as the email always needs to be sent.
Is there a way to do this?
RE: Suppress MS Access message
Julie,
This is a security implementation by Microsoft to ensure no malicious e-mails are sent from your machine (eg. viruses etc).
This is a message generated by each user's machine, and is there to protect users from malicious Access scripts, even though yours is not. Unfortunately there is not a 'Yes, and don't ask me again' option.
"When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the way that attachments are handled by Outlook and the way that Outlook can be controlled programmatically." http://support.microsoft.com/kb/263084
You may be able to adjust settings if your organisation uses Microsoft Exchange: http://support.microsoft.com/kb/290499/
There is also a 3rd party application called 'clickyes', but I believe would need to be installed on every user's machine, which probably isn't ideal: http://www.contextmagic.com/express-clickyes/
Regards, Rich
