Which EVENT does this relate to ?

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

I would like to trigger a macro whe when a user makes an UPDATE/EDIT to a
record and then closes down the form.

I don't want to trigger the macro for every single change the user makes on
a particular record. I only want to trigger it when the user has finally
finished all edits and confirms this by going to a new record or closing
down the form

Help appreciated on identifying form event - thanks!
- Jason
 
jason said:
I would like to trigger a macro whe when a user makes an UPDATE/EDIT
to a record and then closes down the form.

I don't want to trigger the macro for every single change the user
makes on a particular record. I only want to trigger it when the user
has finally finished all edits and confirms this by going to a new
record or closing down the form

Help appreciated on identifying form event - thanks!
- Jason
Click to expand...

The form's BeforeUpdate event fires when the record is about to be
saved, whether it's because the user has moved to a new record, or the
form is closing, or there's been an explicit attempt to save the record.
It doesn't fire as the user modifies the fields in the record, only when
the record is about to be saved -- and you can cancel the save from the
event procedure. Is that the event that you want?

The AfterUpdate event, by comparison, fires immediately after the record
has been saved.
 
If you only navigate through the Record without editing, the AfterUpdate
Event doesn't occur.
 
Great - perfect. I don't suppose you would have any further advice on
triggering an automatic email notification.....my script currently does that
pretty well based on the AfterUpdate and it calls CDO and sends an email
with some basic info about the form...BUT...I cannot help feeling I am
asking for problems with regards resources or particular user settings on
their access database....Am I okay to go with this?
 
You probably know more about than CDO than I do. The last time I sent
e-mails from Access in 1999, I used Outlook97 Automation.

It was a fair effort (sending separate e-mails to 250+ people, each e-mail
has a Word doc. attached. The Word doc has 2 Word Tables filled with data
including derived hyperlinks from Access using Word97 Automation from
Access) and it worked quite well.

Problems???: You don't know until you try ...
 
Thanks - I'll give a smash!!!

- Jason


Van T. Dinh said:
You probably know more about than CDO than I do. The last time I sent
e-mails from Access in 1999, I used Outlook97 Automation.

It was a fair effort (sending separate e-mails to 250+ people, each e-mail
has a Word doc. attached. The Word doc has 2 Word Tables filled with data
including derived hyperlinks from Access using Word97 Automation from
Access) and it worked quite well.

Problems???: You don't know until you try ...
Click to expand...
 
Back
Top