Compile Error: Can't find project or library

G

Guest

I get this msg. when trying to run a procedure. I found an article in the KB
that says to go into Tools/Reference and uncheck the missing reference. Now
the procedures runs as it should.

My question is that are any of my other databases going to be affected by
unchecking the missing reference? I'm guessing not, since the reference was
missing, but I'm not sure how this works. Can someone explain? Thanks so
much -
 
G

Guest

Basically a reference is made to simplify the coding in vba when using
components.

When you don't set a reference then you can create objects(set x =
createobject()) from components but you won't have the handy intellisense in
vba.

Another difference is that when you use components and you put them in
references that VBA can check during compilation whether you use it correctly
if not it will throw an error based in the Schemas stored in the component.

So If you really want to check whether you program will work then you should
do a compile and if no errors are prompted you will be fine.
There is 1 angle to this and that is that queries are not compiled and thus
can not throw an error if you have used a function from a certain component
which is not referenced anymore.
 
G

Guest

Thank you - very helpful

JaRa said:
Basically a reference is made to simplify the coding in vba when using
components.

When you don't set a reference then you can create objects(set x =
createobject()) from components but you won't have the handy intellisense in
vba.

Another difference is that when you use components and you put them in
references that VBA can check during compilation whether you use it correctly
if not it will throw an error based in the Schemas stored in the component.

So If you really want to check whether you program will work then you should
do a compile and if no errors are prompted you will be fine.
There is 1 angle to this and that is that queries are not compiled and thus
can not throw an error if you have used a function from a certain component
which is not referenced anymore.
 

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