how I can create time clock to employee to punch in and out

[Guest]

I would like to create in access a punck clock for employees to clock in and
out. I would like it to display date and time and have a way to make employee
friendly.
any suggestions or examples out there I can look at?

thanks

 

[Ron2006]

From posting by Arvin Meyer


If you mean a clock on a form, you can set the form's TimerInterval
property
to 1000 (which is milliseconds) and use a bit of code like this in the
form's Timer event to make the form's caption show the current data and

time:

Private Sub Form_Timer()
Me.myclockfieldname = Format(Now, "mmmm d, yyyy h:nn am/pm")
End Sub


--
Microsoft MVPs have a question for *you*: Are you patched against the
Worm?
http://www.microsoft.com/security/security_bulletins/ms03-026.asp


Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access