sent notified msg to certain email address.

[Peter chin]

Hi, all the MVPS,

Please help n advice, suppose said i has do some changes in the database.
Is there anyway that i can code it and send a short alert msg to certain
email address ?

So the recipient can alert in the receive email and got to open the database
for reference.

Thanks.

Peter.

 

[Tony Toews]

Please help n advice, suppose said i has do some changes in the database.
Is there anyway that i can code it and send a short alert msg to certain
email address ?

So the recipient can alert in the receive email and got to open the database
for reference.

There are two separate concepts here. The first is to figure out
what changes are being made. The second being the best method of
sending the emails.

1) There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

2) Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Peter chin]

Thanks Mr. Tony.

There are two separate concepts here. The first is to figure out
what changes are being made. The second being the best method of
sending the emails.

1) There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

2) Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm