Thread: How do you add an audit date to field (ie record created xx/xx)
View Single Post
  #3  
Old August 26th, 2009, 04:34 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
  
Posts: 4,732
Default How do you add an audit date to field (ie record created xx/xx)
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??