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 created" field on form
I want to place a field on a form which automatically
indicates the date on which a new record was created/input. I want this date to be non-updatable and unchangeable. I'm assuming there must be a field in the table for this date, but how is it formatted so that the date the record is input (saved) is the date that is shown? Is this even possible? |
#2
|
|||
|
|||
1) Create a Date/Time Field in your table. Call it "AddedOn" or whatever
2) Set "Required" to "Yes" and "DefaultValue" to "Now()" From this point on whenever a new record is created the current Date/Time will be automatically inserted into the field. If you already have records in this table you will have to ignore the error messages you will get when you save the table the first time. You can fill in the "missing" data afterwards with an update query if you desire. To make it non-updateable on the form: add the field to the form and then set the control's Enabled property to False and/or the Locked property to True. -- George Nicholson Remove 'Junk' from return address. "Susan" wrote in message ... I want to place a field on a form which automatically indicates the date on which a new record was created/input. I want this date to be non-updatable and unchangeable. I'm assuming there must be a field in the table for this date, but how is it formatted so that the date the record is input (saved) is the date that is shown? Is this even possible? |
#3
|
|||
|
|||
Great! And thanks for the prompt response!
-----Original Message----- 1) Create a Date/Time Field in your table. Call it "AddedOn" or whatever 2) Set "Required" to "Yes" and "DefaultValue" to "Now()" From this point on whenever a new record is created the current Date/Time will be automatically inserted into the field. If you already have records in this table you will have to ignore the error messages you will get when you save the table the first time. You can fill in the "missing" data afterwards with an update query if you desire. To make it non-updateable on the form: add the field to the form and then set the control's Enabled property to False and/or the Locked property to True. -- George Nicholson Remove 'Junk' from return address. "Susan" wrote in message ... I want to place a field on a form which automatically indicates the date on which a new record was created/input. I want this date to be non-updatable and unchangeable. I'm assuming there must be a field in the table for this date, but how is it formatted so that the date the record is input (saved) is the date that is shown? Is this even possible? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Enter data in 1 text form field & have multiple locations filled i | James | General Discussion | 4 | August 12th, 2004 10:02 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
trouble with setvalue in form | Pei | Using Forms | 5 | July 9th, 2004 12:59 AM |
Stop Word from automatically updating date field when document is opened | Eternal | General Discussion | 4 | June 18th, 2004 01:00 PM |