Time picker for Access 2003

[Thiyagu]

Dear Member's..



I'm trying to do a simple database for my production daily output tracing check sheet..
Someone pls help me on how to do time picker with simple instruction..
Currenthly i need to key in manual under "Time Start" field..
I need a help to use like pop timer , when i choose hours , minutes & second the field will automatic updated..

Any one can help

[SoftwareMatters]

If you type Now() in the default for that field. Every time you add a new record it will default to the current day/time.

If you want a button to add the current time in to a field then on the OnClick of the button in VBA put something like this:

Me!TimeField = Now()

Just substitue TimeField for the name of the field on your form