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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I record the date of the first record entry.



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 06:35 AM posted to microsoft.public.access.tablesdbdesign
Frank Martin
external usenet poster
 
Posts: 162
Default How do I record the date of the first record entry.

I have a small database and I want to record, in a table
field, the date at which a record is added (but not edited).

I want this to be permanent.

Should I make the "primary key" this date?

Please help, Frank


Ads
  #2  
Old May 14th, 2010, 06:45 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default How do I record the date of the first record entry.

"Frank Martin" wrote in message
...
I have a small database and I want to record, in a table field, the date
at which a record is added (but not edited).


In table design view, add the field to record when the entry was made.

In the lower pane of table design, set the Default Value property of this
field to:
=Date()
if you just want the date. If you want the date and time, use:
=Now()

When you create a form to show the entries, don't provide a text box for
this field, so the user won't have a way to modify the date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.




  #3  
Old May 14th, 2010, 07:55 AM posted to microsoft.public.access.tablesdbdesign
Frank Martin
external usenet poster
 
Posts: 162
Default How do I record the date of the first record entry.


"Allen Browne" wrote in message
...
"Frank Martin" wrote in message
...
I have a small database and I want to record, in a table
field, the date at which a record is added (but not
edited).


In table design view, add the field to record when the
entry was made.

In the lower pane of table design, set the Default Value
property of this field to:
=Date()
if you just want the date. If you want the date and time,
use:
=Now()

When you create a form to show the entries, don't provide
a text box for this field, so the user won't have a way to
modify the date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.




Thanks, this worked.


 




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


All times are GMT +1. The time now is 02:37 AM.


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