E-mail notification when table has been updated

[hathman23]

Hello all, I am sort of new using Microsoft Access and Databases but know some various programming information. I currently have a data access page that goes into a table. I simply want an email sent to me when someone enters information into the data access page or updates the table whatever is easiest. Any help would be greatly appreciated.

 

[drrep]

If the user is updating fields from a particular table on a form, then in a field's CHANGE property, enter the code:

DoCmd.SendObject (....)

You can read up on it in the Help file (I don't remember the syntax )

 

[hathman23]

Thanks alot for your response but I guess my question is directed directly at the data access page. When the user inputs the information into the data access page I would like the information to go into the table and also be notified that the table was updated or just have the information sent to both locations.