Access MS Access Approve/deny

Joined
Jul 26, 2012
Messages
2
Reaction score
0
I have created a "Master Table" and forms that can update the master table. Everytime there is a change made through the forms I have it set to go to an audit table.

I want to have an email generated to me where I can view the changes and approve/deny them before they update the master table.

Thank you in advance for your help!
 
application.docmd.RunSQL strErrorLog

If gblnEmailOn Then
application.docmd.OutputTo acOutputReport, "rptErrorLog", acMyFormat, rptErrorLog.snp", True
application.docmd.SendObject acSendReport, "rptErrorLog", acMyFormat, (e-mail address removed), , , "ErrorLog", , False
End If

'Use the Object Browser by queries.
'Rgds Vold
 
Back
Top