Can Access automatically generate email when a field is changed?

[Guest]

I want to be able to automatically generate an email to individual customers
when information in their portfolio changes. I want the email to include the
new information. I want something similar to a trigger in MS SQL where an
xp_sendmail command is generated in response to information in one or more
fields changing.

 

[Dirk Goldgar]

I want to be able to automatically generate an email to individual
customers when information in their portfolio changes. I want the
email to include the new information. I want something similar to a
trigger in MS SQL where an xp_sendmail command is generated in
response to information in one or more fields changing.

Access has no triggers, so you have to either use code when you do
something that changes the information, or else have code that checks
for changes either periodically or when the database is closed. Access
can send e-mails, all right, either by using the built-in
DoCmd.SendObject method or by various other means.