does access have a 'record update' event

  • Thread starter Thread starter al
  • Start date Start date
A

al

I need to update records with a time date stamp if they
have been changed. Is there an event that VB/VBA can
trigger on to force the time stamp?
TIA
al
 
You can use the form's BeforeInsert event to put the date/time stamp into
the appropriate field.
 
I need to update records with a time date stamp if they
have been changed. Is there an event that VB/VBA can
trigger on to force the time stamp?
Click to expand...

Strictly speaking, no. You can use the BeforeUpdate method on the form, but
it's obviously going to miss updates using sql, dao, ado, excel, datasheet
etc.

If you really need a timestamp, you might have to look at MSDE or SQL
Server etc.

Sorry


Tim F
 
ken,
I can't guarantee that the user will use a form to update
the record. I require the guarantee so that the records
can stay in sync with a Visio application that can also
update a parallel record (i.e. two records describing the
same object and using the date stamp to decide which is
the latest update on the system).
al
 
Sorry, I don't have any experience in this area. I was assuming the use of a
form.
 
Back
Top