By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Problems with MSCOMCT2.OCX ActiveX control

P: 18
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?

Apr 10 '08 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 2,653
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?

Apr 10 '08 #2

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

Here's what I'm using:

Expand|Select|Wrap|Line Numbers
  1. 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?
Apr 10 '08 #3

Expert 2.5K+
P: 2,653
What error does it cause?
Are you sure there is no missing library references when running on that machine?
Apr 10 '08 #4

P: 18
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.
Apr 10 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.