If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date
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 -- Jerry Schutt |
#2
|
|||
|
|||
Date
"Jerry" wrote in message
... 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 If you use Date() as the default value for the field then it will record the date the record is created. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Date
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 -- -Larry- -- "Jerry" wrote in message ... 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 -- Jerry Schutt |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding info to query | mjj4golf | Running & Setting Up Queries | 20 | January 9th, 2006 02:29 AM |
Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
Revised Date Question | Spectra | Running & Setting Up Queries | 0 | March 18th, 2005 12:19 PM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
more dates!!! | brigid | Running & Setting Up Queries | 6 | May 26th, 2004 10:59 AM |