mscomct2.ocx

[mp3909]

Has anyone ever encountered an error message saying "Your Microsoft Access database or project contains a missing or broken reference to the file 'mscomct2.ocx' version 2.0" ?

I have spent the last 2 weeks creating an Access database with loads of VBA code built in it and it has been working fine on my computer.

As soon as I tried opening it on someone else's computer, I get that error message.

It then opens up the VBE editor and directs me to the part where I have used "Date" in my code and says missing reference "Microsoft Windows Common Controls - 2 6.0"

Please, if anyone knows how I can fix this, that would be so much appreciated.



Thank You!

[Minty]

What version have you developed this in and what version are you using on the other computer?

Also have you used any Active X componenets?

[mp3909]

Hi Minty,

My version: 14.07229.5000, Office Professional Plus 2010.
My co-worker's version: SAME.

But, I have used Active X component called "Microsoft Date and Time Picker Control 6.0 (SP6)" as I want the user of my application to choose a date in the main form.

[Minty]

The date picker will be your problem.
Active x controls are troublesome when you move forwards through access and windows versions. If possible don't use them.

There is a VBA only date picker here : https://www.access-programmers.co.uk...d.php?t=298062 which will remove the issue.

[isladogs]

The old date control was deprecated in Access 2010.
The old windows control library is no longer installed with Windows and cannot be made to work in 64-bit Windows/Access anyway.
Either use the built in date picker or a non ActiveX replacement such as my better date picker as in the link supplied by Minty or here http://www.mendipdatasystems.co.uk/b...ker/4594398118