Date Control

[SkyEyes]

We recently had to migrate a good portion of our machines to Office 2003
Standard, the rest have Office 2003 Pro. As everyone probably knows, the VBA
code that we utilized for Professional in regards to calendar controls does
not work on Standard machines.

We have tried coding on a Standard machine with date picker and then
Professional get an error that object could not be found. When you look in
references on their machine, nothing is showing as missing.

Does anyone have a calendar control that can utilized on both platforms, or
is something wrong. We need help ASAP. Thanks in advance.

 

[Jonathan West]

We recently had to migrate a good portion of our machines to Office 2003
Standard, the rest have Office 2003 Pro. As everyone probably knows, the
VBA
code that we utilized for Professional in regards to calendar controls
does
not work on Standard machines.

We have tried coding on a Standard machine with date picker and then
Professional get an error that object could not be found. When you look
in
references on their machine, nothing is showing as missing.

Does anyone have a calendar control that can utilized on both platforms,
or
is something wrong. We need help ASAP. Thanks in advance.

Try this
CCRP DateTime Picker/VB6
http://ccrp.mvps.org/index.html?controls/ccrpdtp6.htm

Don't worry that is says VB6. It was written in VB6, but it is a perfectly
straightforward ActiveX control, and the VB6 runtimes are distributed as
part of Office 2003, so you will not need to do more than distribute and
register the control.

Completely free to use.

 

[Graham Mayor]

Or see http://www.gmayor.com/popup_calendar.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[SkyEyes]

So,

What everyone is stating is there is no inherent VBA calendar control in
Microsoft Standard 2003 that is delivered to a user. What is that?? The
question evolves then about the mxcal.ocx if it is licensed, because I do not
see this as a normal download from Microsoft?

 

[Graham Mayor]

I don't have an installation disc for Office 2003 Standard to check, but
mscal.ocx is included with the Office 2003 SP2 update.
http://support.microsoft.com/kb/887616 I make it available from my web site
for convenience as it is required for the function that the web page
discusses.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[SkyEyes]

Interesting. We have Standard 2003 installed and SP2 came down from WSUS and
no MSCAL.OCX file on the box per the Microsoft update. Ideas? I mean I could
push this out to all 5500 workstations, but it seems kind of odd that this
file is not there. It makes me wonder what other files are not on my box.
Mmm...

 

[SkyEyes]

We have the kb887616 SP2 update and there is no file mscal.ocx. We even
loaded Microsoft Office 2003 Standard SP3 and there is still file like this.
Can we copy this from our Office 2003 Professional installation, drop it down
and register it. Is this the same file that you have for download?

 

[Graham Mayor]

According to the Microsoft KB article I quoted it should be included. There
are four versions on my web site to suit Word 97 to 2007, however I see no
reason why you should not use the version you have from Office 2003 which
should be the most recent version.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>