Problems with MSCOMCT2.OCX ActiveX control

[LBryant]

Our team is using a project tracking application built in Access 2000 and upgraded to 2003. We have MS Office 2003 installed on all computers.

On several forms, we're using the Format() function to display dates as "mmm dd, yyyy". The Format function is supported by MSCOMCT@.OCX according to the object browser.

This function causes an error on one of the workstations. Originally, the references dialog showed this control was missing. We copied the file to the system32 folder and registered it. The control is not "missing" any more, but the format function is still causing an error on that one machine.

Does anyone have an idea how to fix this?

Leon

[FishVal]

Hi, Leon.

• What is mscomct2.ocx is all about? Did you mean mscomctl.ocx ?
• To the best of my knowledge there is a pretty nice Format() function - member of VBA library. Why not to use it?
• Are you sure that Format() function you are using is actually from mscomct2.ocx and not from VBA library?

Regards,
Fish

[LBryant]

I think you are right. The Object Browser shows it's part of the VBA library.

Here's what I'm using:

txtStartDate = Format(strStartdate, "mmm dd" & ", " & "yyyy")

This displays Feb 10, 2008 in the text field. If that's the case, and everything else works, why would the Format function cause an error on only one machine?

[FishVal]

What error does it cause?
Are you sure there is no missing library references when running on that machine?

[LBryant]

Thanks FishVal. Here's what I discovered. In Access there were references pointing to 2 different versions of the Microsoft Common Controls -- version 5 and 6. Once I removed the reference to version 5, the Function() control worked without error.

You were correct that the Format function is supported in the VBA library. What I don't understand is why the errant reference caused that particular error.

I also can't understand why it only caused an error on one of our workstations, which are confugured identically.

Oh well, so many questions, so little time. Hope the weather's nice in Israel.