Record the Date and time of record change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, i am not a programmer but a dabbler and have a table of suppliers
with all thier details and the need has arrised to record the date and time
when the record was last changed... Could somebody please either help me
through the process or help me with some code to do this. Thanks in advance.
 
Les said:
Hi all, i am not a programmer but a dabbler and have a table of
suppliers with all thier details and the need has arrised to record
the date and time when the record was last changed... Could somebody
please either help me through the process or help me with some code
to do this. Thanks in advance.
Click to expand...

Can only be done if ALL edits are via a form or update query. In a form you
can use the BeforeUpdate event to set a field in the table to the curretn
date and time...

Me.RevisedOn = Now()

An update query could similarly always include an update on such a field.

There is no way to do this when working directly with a table (which you
should never do anyaway), unless the table was a link to a table in a
database engine that supported Triggers. Then a Trigger could be set up
that would do this globally regardless of the update mechanism used.
 
Thanks very much Rick, the changes are made on a form,
frm_Edit_E90_Supplier_List, which is only accessed by certain people...
However i am getting some conflicting statements as to when the records are
being changed...
 
Back
Top