Re: Date Updated Column
From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/08/04
- Next message: Bruce M. Thompson: "Re: UNC settings"
- Previous message: Duncan Dimech: "UNC settings"
- In reply to: David F: "Date Updated Column"
- Next in thread: Chris: "Date Updated Column"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 7 Mar 2004 19:14:43 -0600
You can use code in the before update event of a form to set the values of
the fields.
-- Duane Hookom MS Access MVP "David F" <davef@nksj.ru> wrote in message news:%23EQhNBKBEHA.1964@TK2MSFTNGP11.phx.gbl... > In SQL Server I can use a trigger to populate a "date created" and "date > updated" field. > > For example, in my orders table I have a "date created" and "date updated" > field. When a row is added to this table, both of these fields are updated > by the trigger with the INSERT date. Later, if the row is modified, the > "date updated" field is modified with the UPDATE date. > > This gives me a nice audit trail for the activity in the table. > > Is there any way to accomplish this in Access? > > Thanks > >
- Next message: Bruce M. Thompson: "Re: UNC settings"
- Previous message: Duncan Dimech: "UNC settings"
- In reply to: David F: "Date Updated Column"
- Next in thread: Chris: "Date Updated Column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
