Automatically Save Default Values

[Guest]

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

 

[Allan Murphy]

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

 

[Guest]

Hi there, Sir Allan!

Thank you very much for the prompt reply. However, it's a shame but I have
to admit I have no idea how to set the AfterUpdate Event property of the
Time-In/Time-out. Please forgive me for that. Please help. Thanks again.
--
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