error : can't find project or library

Question

i have a problem using access i receive this message when i compile " cant find project or library " and on click on a form before opening it shows the message  "your microsoft access database or project  contains missing or broken reference to the file MSCOL.OCX version 7.0 "

i think all the problem is with refrences but im new with access so i don't get it . here are the references checked . could anyone tell me where is the problem ?

Answer 1

Is this an older app being run in 2016? The message is clear. You are using the older Calendar control that is not longer included. Just uncheck  the Missing reference and the message will go away.

You will need to open any forms in design mode that use that calendar control and remove it.

Answer 2

It is a Reference issue indeed.  You can see the line

MISSING: Microsoft Calendar Control 2007

You either have to find a copy of the missing file and register it on the computer, or better yet, ditch the ActiveX component altogether.  For a calendar control, there truly never has been a reason to use ActiveX controls, and as you can see, they simply get you into trouble.

As of 2007, you can use the very limited free date picker, or better, use one of these calendar (which are 100% Access form based, so no versioning issues.

https://www.devhut.net/2010/06/10/ms-access-calendar-date-picker-control/

Answer 3

the database was created on another pc but the same version of microsoft 

should i remove this criteria >=Now() And <=Now()+7 i used it in a query and i called it in the code

Answer 4

I have to doubt that it was created in Access 2016, since that OCX is no longer included.

No, don't remove the criteria, remove the reference.

Answer 5

could you tell me which one plz ?