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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|