Missing referecne file MSCAL.ocx in Access 2007

[Lisa]

Does anyone know how to fix this or where I can go to download the missing
calender reference? I have Access 2007, Windows XP service pack 3

 

[Arvin Meyer [MVP]]

You would set a reference to the file. Run a search for mscal.ocx on your
computer. Once you locate it, set the reference from any code window. Access
2007 doesn't require a calendar ocx so you may just be able to uncheck the
existing reference. If you do need it from the conversion of an older
database, you should be able to get it with Service Pack 1 for Office 2007.

 

[JimfromIndy]

You would set a reference to the file. Run a search for mscal.ocx on your
computer. Once you locate it, set the reference from any code window. Access
2007 doesn't require a calendar ocx so you may just be able to uncheck the
existing reference. If you do need it from the conversion of an older
database, you should be able to get it with Service Pack 1 for Office 2007.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com






- Show quoted text -

This dll was removed from A2007, as I understand it. I did locate it
and put it into my references, but it doesn't seem to work so well. I
downloaded a cool utility that uses it, but never got it to work on
any of my A2007 target or development platforms. I don't know why,
though it appears it has different methods and/or properties than
previous Access versions.

 

[Tom Wickerath]

Hi Jim,

This dll was removed from A2007, as I understand it.

Nope. I just found it on my system, which has Office 2007 Professional
installed. It shows up in the ActiveX controls listing as "Calendar Control
2007". However, do note that Microsoft plans on removing this control from
Access 2010.

Lisa:
There are many alternatives to the Microsoft Calendar control. The .accdb
file format for Access 2007 will automatically display a date picker for
fields bound to a Date/Time data type. I like the calendar that Allen Browne
makes available:

Popup Calendar
http://www.allenbrowne.com/ser-51.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Arvin Meyer [MVP]]

This dll was removed from A2007, as I understand it. I did locate it
and put it into my references, but it doesn't seem to work so well. I
downloaded a cool utility that uses it, but never got it to work on
any of my A2007 target or development platforms. I don't know why,
though it appears it has different methods and/or properties than
previous Access versions.

-----------------

Which is why I've only tested it, and never used it in any professional
applications. Instead I use an Access form which was originally built in
Access 2.0 over 15 years ago and with conversion has worked in every Access
application since:

http://www.datastrat.com/Download/Calendar2K.zip

To use it in an .accdb file, merely convert the database to that format and
import the calendar form and module.

 

[David W. Fenton]

m:

This dll was removed from A2007, as I understand it.

The built-in date picker makes it obsolete.

Also note that it's entirely deprecated for the upcoming A2010:

http://tinyurl.com/yaw3fgp =>
http://blogs.msdn.com/access/archive/2010/01/09/access-2010-deprecate
d-features-and-components.aspx

I don't have any problem with anything on that list except the
replication conflict resolver. Saying "write your own" seems rather
unrealistic of them.