vba combile error: project or object library not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

vba compile error: project or object library not found

This access program has run fine for months but now has this error.

I checked in the code window Tools > References > and no references have
been unchecked since running fine for months.

this error comes on the trim function.

anyone know what is the cause and solution!
tanx
 
Adam.

Sounds like you dropped a reference.

1. Open any code module.
2. From the Tools menu, select References.
3. If you see something marked ***MISSING***, untick it.
4. See if you can find whatever was missing (probably Microsoft DAO 3.x
Object Library), and tick it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
yes! It said
Missing- VB scripting
so i unticked and re ticked but it did not fix it. Now that I know what is
missing, how to fix problem.

you said a reference was drooped, what is likely cause of drop? user
deleting files ? bad lick?lol
 
I am going to reinstall access to see if that fixes problem. think thsi will
take care of it?
 
reinstall did not fix it is :microsoft scripting runtime that is missing

Specifically, the missing reference is ...

Missing: Microsoft scritping runtime
 
<<...did not fix it>>
Did you tick Microsoft DAO 3.x Object Library? If not, go back into
References and tick it.

<<...what is likely cause of drop?>>
Bad luck, a disturbance in the force, the dog ate it, terrorist attack - who
knows?!?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
I could have told you a reinstall wouldn't do it.

Make sure Microsoft DAO 3.x Object Library is referenced. If that doesn't
fix it, try Compact and Repair. Failing that, decompile it, then recompile.

To decompile the database, create and execute a Windows shortcut using the
/decompile switch.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
I copied a scrrun.dll file to the winnt\system32 and solved the problem.
But now there is an active x file missing which is my next post.

Basically, the person said she removed a program on this computer yesterday
and appareantly removed some dependency files shared with this access project.

But in references it showed MISSING just as you said for runtime scripting
file and gave the path and file it could not find, but on this missing active
X component file, the reference box does not tell me what is missing.

My other post I am asking if anyone knows which file I may be missing ir how
to find out.
 
Back
Top