Date and Time Stamp

  • Thread starter Thread starter alan
  • Start date Start date
A

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
 
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
 
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.
 
Couldn't have said it better myself.
--
Joe Fallon
Access MVP



martyn said:
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
.
Click to expand...
Click to expand...
 
Back
Top