A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Date created" field on form



 
 
Thread Tools Display Modes
  #1  
Old August 25th, 2004, 06:21 PM
Susan
external usenet poster
 
Posts: n/a
Default "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  
Old August 25th, 2004, 07:00 PM
George Nicholson
external usenet poster
 
Posts: n/a
Default

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  
Old August 25th, 2004, 07:08 PM
Susan
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.