calendar picker

[mark kubicki]

how do i add a calendar picker; it doesn't show in my tool box, and when i'm
in VB editing the form, i can't seem to get to "other tools" (not that i
would know what it's called...

thanks in advnce (again)
mark

 

[Robin Hammond]

Mark,

It's called the calendar control. If you have it, it is located in your
office folder with the file name mscal.ocx.

I think this only comes with Access installed, and maybe visual studio. You
should be careful if you intend to redistribute the workbook, because other
users may not have the control installed. Alternatively, there is the
Microsoft Date and Time Picker Control. Mine is in system32\mscomct2.ocx. I
think that one is a visual studio installation rather than something that
comes with office. You'll probably have it on your machine somewhere as part
of someone else's installation but should check out redistribution rights if
you want to send your project out to other users.

Robin Hammond
www.enhanceddatasystems.com

 

[mark kubicki]

i'm surprised that it's not part of the MS package... it's such a common
tool: it certainly shows up in outlook, as well as on dozens of web sites