Re: Automatically Save Default Values



Using the AfterUpdate event of the Employee Number you could set the Time_In
value to Now().

You would also need to day something similar for the Time_Out

--
Allan Murphy
Email: allanmurphy@xxxxxxxxxxxxxx
"Resty" <plsdonotsendmail@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6013E8C6-BF1F-4CEB-AC54-7B879C59DEA7@xxxxxxxxxxxxxxxx
Hi, Guys! Good morning/afternoon/evening!

I have a simple bundy clock application using microsoft access 2003. My
dafault values for Time-In is TimeValue(Now()) and for Time-Out is also
TimeValue(Now()).

Presently, my employees type the Time and click the "Punch In/Out" Button
before the record is saved, and I find the process a little awkward
because
the idea of having an automated bundy clock system is to log the
employees'
time when he/she punches in/out using the computer's system clock.

Now what I want to happen is to have the record saved automatically when
the
employee strike the Enter key after typing their Employee Number.

Please help me on this and thank you very much in advance.
--
My sincerest thanks. . . and may the good Lord bless you always and give
you more knowledge and intelligence to share with us novice. Thank you
very
much!

Resty A. Morales


.