August 26th, 2009, 07:58 PM
posted to microsoft.public.access.gettingstarted
|
|
|
How do you add an audit date to field (ie record created xx/xx)
Sweet!
Jeff
"John Spencer" wrote in message
...
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 wrote:
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
"Jerry Whittle" wrote in message
...
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
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"ko779" wrote:
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??
|