does access have a 'record update' event

[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

 

[Ken Snell]

You can use the form's BeforeInsert event to put the date/time stamp into
the appropriate field.

 

[Tim Ferguson]

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?

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

 

[al]

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

 

[Ken Snell]

Sorry, I don't have any experience in this area. I was assuming the use of a
form.