Calendar Date and time picker

[Zigzag]

Hi All,

I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique.

No modules, very little code, code used is simple and can be called from subforms as well as forms.

I used these forms in an application where the users find filling in date and times in the correct format difficult with limited keyboard skills.

If it can be improved let me know.....

Garry

PS I think the contributions Banana has been making to this forum are invaluable.
Keep up the good work.

 

[GaryPanic]

Hi All,

I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique.

No modules, very little code, code used is simple and can be called from subforms as well as forms.

I used these forms in an application where the users find filling in date and times in the correct format difficult with limited keyboard skills.

If it can be improved let me know.....

Garry

PS I think the contributions Banana has been making to this forum are invaluable.
Keep up the good work.

what version of access?

 

[Zigzag]

Sorry, never mentioned Access 2003,

MSCAL.OCX required.

Garry

 

[mreyes46]

date-time picker

beautiful, thank you!

 

[Zigzag]

Your welcome,

I have made some slight modifications that I will post here when I get the chance.

 

[nguyenthoavira]

thank so much!

 

[ntyler1]

Thanks zigzag for sharing. Was very helpful.

 

[tnt203]

Hi All,

I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique.

No modules, very little code, code used is simple and can be called from subforms as well as forms.

I used these forms in an application where the users find filling in date and times in the correct format difficult with limited keyboard skills.

If it can be improved let me know.....

Garry

PS I think the contributions Banana has been making to this forum are invaluable.
Keep up the good work.

Hi Garry,

I download the popup calendar, and modified it to work with my access. I don't have the subform in my form. I had no problem changing the code, however, when the calendar popup, and I picked the date, after I click on save, and it gets back to my form, the date field not automatically updated with the new date, I have to click on another field then the date field will get updated with ne date. I have tried to use different Events, such as On Get Focus, On Lost Focus, On current, but none worked. Any suggestion?
Thanks for you help,
Tung