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?

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" <(E-Mail Removed)> wrote in message
news:B5BF9C4B-5B17-4879-86E7-(E-Mail Removed)...
>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?

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" <(E-Mail Removed)> wrote in message
> news:B5BF9C4B-5B17-4879-86E7-(E-Mail Removed)...
> >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?
>
>
> .
>