Results 1 to 5 of 5
  1. #1
    neuhur is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    11

    Automatically Send/Generate Email When A Button Is Pressed

    Hello Everyone,

    I am very new to MSA2010 and I am working my way though it. However, I need your assistance.

    I created a button (using the button wizard) that will allow a user to delete a record. However, I need to be notified via an auto-generated email that will be sent to me informing me that a record was deleted. I do not want the user to know that the email was sent to me. What is the easiest way to accomplish this?



    Thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Making this transparent to the user will not be easy, maybe impossible, because it has to use their account as the FROM address. EDIT: I keep forgetting about CDO, see next post.

    Easiest thing to do is save data to an audit table with an audit log procedure and then review the table periodically.

    Review: http://allenbrowne.com/AppAudit.html
    Last edited by June7; 01-29-2014 at 06:14 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You could send an email using CDO. Another option would be to use a texting service. You could use a texting service's host via an API to text an SMS to you.

    Now I will ask, why, when you could just write data to a table and look inside the table periodically. If you need to catch someone in the act I recommend SMS.

  4. #4
    neuhur is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    11
    Thanks for the info!

    Yes, we have been having some issues with people altering the data.

  5. #5
    neuhur is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    11
    Thanks for the info!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. "Send Email" button on Query-Based Report
    By athyeh in forum Programming
    Replies: 5
    Last Post: 07-05-2013, 12:44 PM
  2. Replies: 2
    Last Post: 01-24-2013, 09:03 AM
  3. Replies: 3
    Last Post: 04-17-2012, 03:26 PM
  4. Replies: 4
    Last Post: 10-28-2011, 03:28 PM
  5. Replies: 4
    Last Post: 04-13-2011, 10:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums