How set up automatic date population when new record received

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rickym - 16 Aug 2005 14:00 GMT

I'm fairly new to ACCESS (and not very knowledgable in it's technical
aspects). Can someone please give me advice on how to create a field in an
ACCESS database (table) that will automatically register the current date
when a new record is posted to the database (that is, the date that the
posting of the new record took place). Is it a field on the table? Or, some
other programming? Thanks...

Reply to this Message

Duane Hookom - 16 Aug 2005 14:56 GMT

You can set a default value of a field to either Date() or Now(). The Now()
function returns date with a time element. When a new record is added to the
table, this field will default to the current date or date and time.

Signature

Duane Hookom
MS Access MVP
--

> I'm fairly new to ACCESS (and not very knowledgable in it's technical
> aspects). Can someone please give me advice on how to create a field in
[quoted text clipped - 4 lines]
> some
> other programming? Thanks...

Reply to this Message