D
Dennis _M
I have an Access 2003 database I use to keep track of projects I'm working
on. Within the main form, I have a comments subform where I keep a history of
actions taken for each project.
What I would like to do is to send a copy of a record to the appropriate
engineer (I have an engineer form/table that includes email addresses) each
time I update the comments subform, as an email (I always have Outlook on).
I've been reading different posts that do something similar, but am still
confused on how to accomplish this. I could write an Event procedure for the
OnExit event in the comments subform, but would have to do that for each
project (I'm sure there's a way to do this globally). I've seen some info on
using the Snapshot Viewer, but I'm not sure that is the correct approach.
I have no preferences on how to accomplish this, other than I would prefer
to code this, believing this to be more robust than using a macro (I'm adding
capability to this database as I "baby step" my way (What About Bob?)).
Any suggestions?
on. Within the main form, I have a comments subform where I keep a history of
actions taken for each project.
What I would like to do is to send a copy of a record to the appropriate
engineer (I have an engineer form/table that includes email addresses) each
time I update the comments subform, as an email (I always have Outlook on).
I've been reading different posts that do something similar, but am still
confused on how to accomplish this. I could write an Event procedure for the
OnExit event in the comments subform, but would have to do that for each
project (I'm sure there's a way to do this globally). I've seen some info on
using the Snapshot Viewer, but I'm not sure that is the correct approach.
I have no preferences on how to accomplish this, other than I would prefer
to code this, believing this to be more robust than using a macro (I'm adding
capability to this database as I "baby step" my way (What About Bob?)).
Any suggestions?