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  

Default Value =now() in table



 
 
Thread Tools Display Modes
  #1  
Old January 29th, 2010, 09:35 PM posted to microsoft.public.access.tablesdbdesign
Steve Stad
external usenet poster
 
Posts: 89
Default Default Value =now() in table

I have a Default Value of =now() for a DateEntered field formatted as General
Date. I noticed when I copy pasted a group of 4 records the DateEntered
field did not update automatically. Could it be because I copy/pasted a
block of records or can you tell me when/how it is supposed to update
automatically from w/in the table. The DateEntered works OK on the form but
the form add/enters one record typed at a time - is that the difference?
  #2  
Old January 29th, 2010, 11:55 PM posted to microsoft.public.access.tablesdbdesign
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Default Value =now() in table

Realistically, copy-and-paste is seldom a good idea when working with
databases.

Default values only apply for new records, and you're allowed to overtype
the value before the record's saved. Since the records you're copying
presumably have the DateEntered field populated, Access takes that value,
since there's no need for a default value!

More appropriate than copy-and-paste is to run an Append query and specify
which fields should be appended (in addition to which rows)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Steve Stad" wrote in message
...
I have a Default Value of =now() for a DateEntered field formatted as
General
Date. I noticed when I copy pasted a group of 4 records the DateEntered
field did not update automatically. Could it be because I copy/pasted a
block of records or can you tell me when/how it is supposed to update
automatically from w/in the table. The DateEntered works OK on the form
but
the form add/enters one record typed at a time - is that the difference?



  #3  
Old February 1st, 2010, 05:14 PM posted to microsoft.public.access.tablesdbdesign
Steve Stad
external usenet poster
 
Posts: 89
Default Default Value =now() in table

Thanks Doug - You are exactly right. TimeStamp for date entered works
w/Append. Now - I see the blank value I was pasting in date entered
overtypes the default value =now().

"Douglas J. Steele" wrote:

Realistically, copy-and-paste is seldom a good idea when working with
databases.

Default values only apply for new records, and you're allowed to overtype
the value before the record's saved. Since the records you're copying
presumably have the DateEntered field populated, Access takes that value,
since there's no need for a default value!

More appropriate than copy-and-paste is to run an Append query and specify
which fields should be appended (in addition to which rows)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Steve Stad" wrote in message
...
I have a Default Value of =now() for a DateEntered field formatted as
General
Date. I noticed when I copy pasted a group of 4 records the DateEntered
field did not update automatically. Could it be because I copy/pasted a
block of records or can you tell me when/how it is supposed to update
automatically from w/in the table. The DateEntered works OK on the form
but
the form add/enters one record typed at a time - is that the difference?



.

 




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 05:23 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.