Removing references to mscal.ocx

backfromthebush

New Member
Joined
Jul 2, 2010
Messages
37
Hi all,

I have a database built that was built in Access 2003. We are migrating to Access 2010, and get the error "You Microsoft Access database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0".
I understand that this is to do with the calender control, which is activated generally by a textbox on event double-click and up pops the calender template.
Quite simply, I want to remove any reference to this calender control and calender template, and just use the built in calender picker.
Is there an easy way to remove all references to MSCAL without having to go into each individual form??
:)
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Unfortunately Not.

You will need to open each form and remove the reference and change the setting to use the date picker.

FWIW: The built in date picker is very limited. I have not found it very useful for most apps. I use a pop-up calendar made with native Access controls. This way is will always work in any version of Access. See: Calendar Links
 
Upvote 0

Forum statistics

Threads
1,224,604
Messages
6,179,857
Members
452,948
Latest member
UsmanAli786

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top