Date Time picker (2003 SP2)

[Abraxus]

I've read about the Microsoft Date and Time Picker but for the life of me, I can't find in on my computer.

I imagine I should click More Controls from the toolbox and scroll until I find it, right?

Well, it's not there.

What gives?

[HansV]

The Calendar control comes with Access, but the Date/Time picker doesn't - it's part of such programs as Visual Basic 6. Even if you had it, it's quite possible that your users don't.

[Abraxus]

Ok, any suggestions for a time picker for Access?

[HansV]

Sorry to be a nuisance, but why would you want a time picker? I can understand the use of a date picker, but a time picker doesn't add much in my opinion...

[Abraxus]

No nuisance...good question.

I'm working on a time clock application that will require the management to add time punches if the employees miss one or if one needs to be corrected.

Have a better idea? I'm open to suggestions.

[HansV]

There are several free custom date pickers using only native Access controls, but I haven't seen free custom time pickers. I'd simply use a text box whose Format property is set to Short Time. It will only accept valid times.

[Abraxus]

I think I will use combo boxes. 1 for the hour, 1 for the 10's value of the minutes, and 1 for the 1s value of the minute.

It will default to the current time and users can change as appropriate.

Now I just have to get that into a format to match my time stamp in the table.

[HansV]

That is certainly possible, but it's a lot of extra work...

[Abraxus]

I agree that it is extra work for me, but it sure beats the heck out of training employees how to input the time in the proper format.

I got it working and it works like a champ.