Solved VBA code for emailing an individual when a record is deleted from a table(s)

[chickenwings23]

Hi,

Is there a possible code to notify the Access Database Admin through outlook email once a deletion occurs from a particular table or tables?

For example, there are ten records in such a table. The user deletes one because it is unnecessary, but the database administrator wants to be notified about the deletion and what was deleted from the table. If anyone has an example to showcase or code, that'd be beneficial.

Thanks!

 

[June7]

Did you search for code samples? Likely won't find something specific but automating email is a common topic. Examples should be adaptable. Real trick is figuring out what event to put code into. Possibly use form BeforeDelete event.

Deleting records should be a rare occurrence. Do you really want to allow this? Better may be to just 'flag' a record as "Inactive". Can still send email but recovering record is simply matter of changing field value.