M Mike Jan 25, 2004 #1 How can I automatically insert the current time/date in a field when a new record is created? Thanks.
How can I automatically insert the current time/date in a field when a new record is created? Thanks.
C chriske Jan 25, 2004 #2 Mike a formulé ce zondag : How can I automatically insert the current time/date in a field when a new record is created? Thanks. Click to expand... just add date() or now() as standard value in an empty unused date field wich cannot be edited in your application GUI grtz
Mike a formulé ce zondag : How can I automatically insert the current time/date in a field when a new record is created? Thanks. Click to expand... just add date() or now() as standard value in an empty unused date field wich cannot be edited in your application GUI grtz
D Douglas J. Steele Jan 25, 2004 #3 Add a CreateDt field to your table, and set its default value to Now() (if you want the date and time) or Date() (if you only want the date)
Add a CreateDt field to your table, and set its default value to Now() (if you want the date and time) or Date() (if you only want the date)
