Time stamp for modifying a record

[ibeetb]

I know of a timestamp for adding a new record to a table but is there some
way I can add a timestamp each time I modifty a record? Either in the table
design or in VBA would be fine

Thanks

 

[Rick B]

Sure, just add a field and then build code into your forms that updates that
field before a change is written. I think it is the "before update" event
that you want.

 

[Guest]

The only way I know of would be to create a form to modify your data
(perfered method of editing data instead of directly working with the table),
then in the forms before update event add
Me![YourFieldName] = Now

 

[dbahooker]

yet another reason that MDB is obsolete.

use Access Data Projects and SQL Server.

it is 100 times better in the short term and the long term.

your users will thank you

The only way I know of would be to create a form to modify your data
(perfered method of editing data instead of directly working with the table),
then in the forms before update event add
Me![YourFieldName] = Now

I know of a timestamp for adding a new record to a table but is there some
way I can add a timestamp each time I modifty a record? Either in the table
design or in VBA would be fine

Thanks