Compiler error: Can't find project of library.

D

Dick

I am using Access 2003. I have Visual Basic For Applications as an
Available Reference. When it gets to "Date" in the code I get a
Compiler error: Can't find project of library. Can anyone help?
 
A

Allen Browne

Sounds like either a bad reference or a naming clash.

In the code window, choose References on the Tools menu.
Anything marked "MISSING"?
If so, see:
Solving Problems with Library References
at:
http://allenbrowne.com/ser-38.html

If not, you have something else named Date, which is a reserved word in VBA
(and also in SQL.) Find and rename it. If it is a field, you may need to
rename it in your queries and table as well.

If you have no field with that name, and it is not the name of your form,
control, or variable, and there is no function or sub with that name,
perhaps it is the name of the project. The project name shows up on the
tools menu in the code window, e.g. it would read:
Date Properties
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top