K
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??
would like to capture the name as well.
How do you do it??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
[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
J
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
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
J
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
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
J
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
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
J
Jeff Boyce
Sweet!
Jeff
Jeff
John Spencer said: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