MS Access Approve/deny

Discussion in 'Windows 7' started by robtech, Jul 26, 2012.

  1. robtech

    robtech

    Joined:
    Jul 26, 2012
    Messages:
    2
    Likes Received:
    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!
     
    robtech, Jul 26, 2012
    #1
    1. Advertisements

  2. robtech

    Vold

    Joined:
    Aug 7, 2012
    Messages:
    10
    Likes Received:
    0
    Location:
    Germany
    application.docmd.RunSQL strErrorLog

    If gblnEmailOn Then
    application.docmd.OutputTo acOutputReport, "rptErrorLog", acMyFormat, rptErrorLog.snp", True
    application.docmd.SendObject acSendReport, "rptErrorLog", acMyFormat, Me@Them.com, , , "ErrorLog", , False
    End If

    'Use the Object Browser by queries.
    'Rgds Vold
     
    Vold, Aug 9, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. mccouch

    MS Access SQL error

    mccouch, Nov 12, 2010, in forum: Windows 7
    Replies:
    0
    Views:
    754
    mccouch
    Nov 12, 2010
  2. russb
    Replies:
    1
    Views:
    1,066
    russb
    Aug 25, 2011
  3. cbertsch

    Importing from Excel to Access

    cbertsch, Mar 2, 2012, in forum: Windows 7
    Replies:
    0
    Views:
    1,132
    cbertsch
    Mar 2, 2012
  4. Mihai

    MS Access Required Fields

    Mihai, Aug 10, 2012, in forum: Windows 7
    Replies:
    0
    Views:
    821
    Mihai
    Aug 10, 2012
  5. sireesha

    MS ACCESS 2007

    sireesha, Oct 16, 2012, in forum: Windows 7
    Replies:
    2
    Views:
    1,123
Loading...

Share This Page