Compile Error: Can't find project or library

  • Thread starter Thread starter Guest
  • Start date Start date
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 -
 
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.
 
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.
Click to expand...
 
Back
Top