How do you add an audit date to field (ie record created xx/xx)

[ko779]

I'm trying to catch the date in my Access db of when a new record is created,
would like to capture the name as well.

How do you do it??

 

[Jeff Boyce]

One approach is to add another field to the table to hold something like
[UpdateDate]. Then, in your form (you ARE using a form, right?!), you can
set the value of that field to today's date (or today's date/time). The
AfterUpdate event for the form (one of the many good reasons to be using
forms, not working directly in the tables) would be a convenient place to
set that value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jerry Whittle]

The date for a new record is easy. Make the default value of a date field in
the table either Date() - which is just the date - OR Now() which is the date
and time.

Who did it is a little more complicated. Below is a link to a function that
will pull it. However you will need to run this function in a form on
something like the Before Insert event. If someone enters data directly into
the table, it will not work.

http://mvps.org/access/api/api0008.htm

 

[Jeff Boyce]

Jerry

I've used that approach too, but I have 'long-winded' customers who start a
new record and walk away. By waiting 'til they 'close' the new record, I
get a more accurate date/time value...

But maybe you've been blessed by 'prompt' customers!<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

You can use both approaches at the same time.

Default value = Now() will work well if you ever import records and if you
really want to now approximately when the record was committed using the
form's after insert event can overwrite the default value.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Jeff Boyce]

Sweet!

Jeff

You can use both approaches at the same time.

Default value = Now() will work well if you ever import records and if you
really want to now approximately when the record was committed using the
form's after insert event can overwrite the default value.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County