PC Review

Thread Tools Rate Thread

MS Access Approve/deny

New Member
Join Date: Jul 2012
Posts: 2
      26th Jul 2012
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!
Reply With Quote
New Member
Join Date: Aug 2012
Location: Germany
Posts: 10
      9th Aug 2012
application.docmd.RunSQL strErrorLog

If gblnEmailOn Then
application.docmd.OutputTo acOutputReport, "rptErrorLog", acMyFormat, rptErrorLog.snp", True
application.docmd.SendObject acSendReport, "rptErrorLog", acMyFormat, http://www.pcreview.co.uk/forums/(E-Mail Removed), , , "ErrorLog", , False
End If

'Use the Object Browser by queries.
'Rgds Vold
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dialing from an Access form / Access 97 & Access 2000 Abay Microsoft Access Forms 2 12th Jun 2005 01:17 AM
W2K3 Service w/ UNC Access, Local Disk Access, and DB Access Rob Microsoft C# .NET 6 2nd Aug 2004 01:44 PM
Access "showing images on first page only of very wide Access report. Windows XP, Access XP Jack Microsoft Access Reports 4 18th Nov 2003 04:01 PM
Re: Allowing users (w/o MS Access) to access an Access 2000 database Wayne Morgan Microsoft Access 0 29th Sep 2003 11:46 PM
Re: Allowing users (w/o MS Access) to access an Access 2000 database John Vinson Microsoft Access 0 29th Sep 2003 07:03 PM




All times are GMT +1. The time now is 09:30 PM.