Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry - 16 Feb 2006 23:49 GMT

I have a table where I input new customers. I want the date the customers
are inputted to be logged. Can Access automatically update the date field
when a new record is created.
I have not created the form yet, just the table, and I am using the date ()
function which gives me the present date, not the date the customer was
inputted.
thanks

Signature

Jerry Schutt

Reply to this Message

Rick Brandt - 17 Feb 2006 00:07 GMT

>I have a table where I input new customers. I want the date the customers
> are inputted to be logged. Can Access automatically update the date field
[quoted text clipped - 3 lines]
> inputted.
> thanks

If you use Date() as the default value for the field then it will record the
date the record is created.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Larry Daugherty - 18 Feb 2006 13:22 GMT

Put a new control on your form based on your date field - I recommend
naming it something else, like "StartDate". For the default value for
the control on the form enter "=Date()"

HTH

Signature

-Larry-
--

> I have a table where I input new customers. I want the date the customers
> are inputted to be logged. Can Access automatically update the date field
[quoted text clipped - 3 lines]
> inputted.
> thanks

Reply to this Message