Results 1 to 10 of 10

Thread: help with after insert event in Access 10

  1. #1
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0

    help with after insert event in Access 10

    I have a table that multiple users can update it via filling a form and emailing it. I have another table with the users details including the email address.
    I want to send an automatic confirmation email so that the user knows that the data they have sent has been captured and updated in the database. I was trying to use the after insert event feature in access 2010 but as i am not so well versed i need help.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Richlyn, welcome to ExcelFox

    You might want to tell how your table gets updated just by emailing a form.

    Did you try the e-mail codes provided in this forum?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    I am using Access 2010.
    I use the feature "Create Email" to "collect data" and then when users reply by filling the form in the sent email the table is updated with a new record.

    I just want to send the user a email for confirmation stating that their data has been updated in the table and also mention what they had filled in the form for validation purposes.

  4. #4
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    Last edited by DocAElstein; 09-22-2023 at 05:01 PM.

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    I have made a after insert event using the Access GUI feature which looks like this.

    Afterinsert.jpg

  7. #7
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    I am not able to populate the email address in the to field which needs to picked up from a referenced table.

  8. #8
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    Okies i got that fixed after a lot of googling and asking help from coleagues..

  9. #9
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi richlyn,

    Could you please share the solution here ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  10. #10
    Junior Member
    Join Date
    Dec 2011
    Posts
    8
    Rep Power
    0
    here is the code that i used in the access 2010 UI macro event...
    Attached Images Attached Images

Similar Threads

  1. Macro To Insert Columns In Excel
    By jac3130 in forum Excel Help
    Replies: 2
    Last Post: 05-17-2013, 07:49 AM
  2. Automatically Insert Row
    By marreco in forum Excel Help
    Replies: 7
    Last Post: 12-21-2012, 06:43 PM
  3. Insert Picture in a Cell UDF
    By Admin in forum Download Center
    Replies: 10
    Last Post: 12-07-2012, 04:49 PM
  4. Worksheet_Change event
    By Excelfun in forum Excel Help
    Replies: 2
    Last Post: 11-21-2012, 07:24 AM
  5. Insert 'n' number Rows after any specified row no.
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 11-08-2011, 08:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •