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
|
|||
|
|||
Automatic date that doesn't change
How can I add a date field on a form that pops in today's date automatically,
but that then stays at that date? In other words, I want it to be the date the record was added, but not to update each time the record is accessed by a user. Thanks! MEOlsen |
#2
|
|||
|
|||
To record the creation date, create a date/time field in your table and make
the default value Date() -for date only, or Now() for date and time. You may want to create a second date/time to record updates. For that field, add a code line to the AfterUpdate event of its bound form control like: Me![myDate]=Date() -Ed "MEOlsen" wrote in message ... How can I add a date field on a form that pops in today's date automatically, but that then stays at that date? In other words, I want it to be the date the record was added, but not to update each time the record is accessed by a user. Thanks! MEOlsen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Date Navigator, how do I change color of currently viewed date | gcsmithsr | Calendar | 0 | June 8th, 2005 07:58 PM |
Newbie Q - Macro to change date in all files | Trev Maxwell | General Discussions | 5 | May 15th, 2005 06:56 PM |
Automatic Date | Aurora | Using Forms | 1 | May 2nd, 2005 04:28 PM |
Automatic Date Update | dwayne | Worksheet Functions | 1 | January 23rd, 2004 09:29 AM |
cell to change colour at given date - how to | Tobit | Worksheet Functions | 2 | September 17th, 2003 12:20 PM |