time/date stamp when input is presented

[Creslin]

I am relatively new to access and I was wondering if this is even possible
and if so how would I go about doing it. I need to make a program that every
time you input a number in the database, it will automatically timestamp when
the input occured. If this is possible, please help. I am getting very
frustrated with this.

 

[Golfinray]

On your form, go into properties/events and click on beforeupdate. Start the
code builder (little button out to the right) and type:
Me.Last_updated = Now()

 

[Al Campagna]

Creslin,
Assuming the entry is by form... not table...
Use the AfterUpdate event of your number field (ex. MyNumber)
You'll need to add a Date/Time field to your table (ex. DOLE (which
means Date Of Last Edit)), and add that field to your form.

Private Sub MyNumber_AfterUpdate()
DOLE = Now()
End Sub

When you enter the number, or change the number, DOLE will update with
the current Date&Time.
--
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."

 

[Al Campagna]

Creslin,
I'd add that I have a sample file A97 and A2003 (Record Statistics) on
my website (below) that shows how to capture 2 values.
DOC = Date of Creation (of the record)
DOLE = Date of Last Edit (of the record)
That might be helpful... as regards getting those values... for just one
field (per your post)
--
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."

 

[Creslin]

Thank you for all your help, it is greatly appreciated. I was able to get
the form to work and capture the time just as I wanted.