View Single Post
  #3  
Old February 1st, 2010, 04: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?



.