MS Access Approve/deny

Access Discussion in 'Microsoft Office' started by robtech, Jul 26, 2012.

  1. robtech

    robtech

    Joined:
    Jul 26, 2012
    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
    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. LimitedAccess

    Access MS Access: If/Then Report Salutation

    LimitedAccess, Jun 2, 2005, in forum: Microsoft Office
    Replies:
    5
    Views:
    904
    cvo-aalst
    Jun 19, 2005
  2. abaxt

    Access Input Variable SQL to MS Access Project ????

    abaxt, Jun 14, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    634
    abaxt
    Jun 14, 2005
  3. tevigen

    Access MS Access - Emailing Subform Data

    tevigen, Jun 15, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    653
    tevigen
    Jun 15, 2005
  4. allisond

    Access MS Access 2000 to MS Access 2002 problem

    allisond, Mar 23, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    285
    allisond
    Mar 23, 2006
  5. ajetrumpet

    Word MS Access Wordpad OLE objects

    ajetrumpet, Oct 2, 2008, in forum: Microsoft Office
    Replies:
    3
    Views:
    2,520
    JaLing
    Oct 2, 2008
  6. shailesh_bali

    Excel MS excell File Error, MS Win XP Professional Version 2002

    shailesh_bali, Nov 17, 2009, in forum: Microsoft Office
    Replies:
    1
    Views:
    571
    Chuck D
    Jan 3, 2010
  7. ahmsuza

    Excel MS Access 2010- Excel templete autofill from form record

    ahmsuza, Jul 23, 2013, in forum: Microsoft Office
    Replies:
    0
    Views:
    901
    ahmsuza
    Jul 23, 2013
  8. NickCee

    Excel MS Excel - MS Office 2010

    NickCee, Jul 11, 2016, in forum: Microsoft Office
    Replies:
    0
    Views:
    565
    NickCee
    Jul 11, 2016
Loading...