Compile Error

[hooby1]

When opening a database what does this message mean: Compile Error Can't find project or library. It then hightlights a line of code (Date)
Cheers

 

[Pat Hartman]

Obviously since Date is an integral function, this isn't the real problem. Go to Tools/References and look for a MISSING reference. A likely culpret is the DAO library. For more info, search here. This is an extremely common problem. When there is a missing reference, Access just stops at the first function it encounters. Since Date is probably the most commonly used function, that is the one that usually shows up and confuses everyone.

 

[hooby1]

Thanks of the help. Forgot to say that this is in version 97 and so References isn't in the tools option. Any other ideas how to get around it?

 

[Pat Hartman]

It is still a references issue. I don't remember where that menu is if it isn't under Tools but search around.

 

[Jacob Mathai]

open a module in design. Then tools/reference