Date and Time Stamp

[alan]

Hi,

Is there a way of having the date and time that an entry
was made in a particular field in a form automatically
recorded and saved in my database?

TIA

Alan

 

[martyn]

Ive been working on the same thing the past couple of
days. Im a novice so im sure an expert could tell you
better, but you need to create a date/time field. The
record that you are going to view or change, use the
afterupdate, then code builder, then
[Whateveryourtimefieldnameis] = Now()

hope that helps

 

[Vel]

Hello,

If you only want to do this when a user adds a new record
(not when a record is changed), just add a date/time
field to your table and set its default value to =Now()

Vel.

 

[Joe Fallon]

Couldn't have said it better myself.
--
Joe Fallon
Access MVP

Ive been working on the same thing the past couple of
days. Im a novice so im sure an expert could tell you
better, but you need to create a date/time field. The
record that you are going to view or change, use the
afterupdate, then code builder, then
[Whateveryourtimefieldnameis] = Now()

hope that helps

-----Original Message-----
Hi,

Is there a way of having the date and time that an entry
was made in a particular field in a form automatically
recorded and saved in my database?

TIA

Alan
.