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 |
#11
|
|||
|
|||
How do I save the date a record was last modified in Access 2003
Did you read Clifford Bass's response. He makes additional good
points to consider... -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "David W. Fenton" wrote in message 36.90... "Clifford Bass via AccessMonster.com" u48370@uwe wrote in news:a148c2c00e97c@uwe: I find setting the default values for date/time fields in Access to Date (), Now() or Time() to be highly inaccurate because the value is set when the new row is displayed, not when data is initially being entered and not when it is actually saved. So if I go to a new record on 12/28/2009 at 11:50 pm, but do not actually start entering anything until 12/29/2009 at 12:15 am and do not actually save it until 12/29/2009 at 12:45 am, it will save with a creation date of 12/28/2009 and a creation time of 11:50 pm. Which is just plain wrong. That's something I never considered. But I still prefer the default values in the table, nonetheless. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|