Error Message: Cant Find Object or Library

[sush]

Hi,

I get this message on various parts of the database i have created, some code that has been used is from other sources - web etc.

I get this message Cant Find Object or Library. and then that part of the application does not work.How can i resolve this problem.

I also get this message when i use something apparantly within Access UCASe & LCASE to enbale char's to automaticly go upper or lower case and also 'FORMAT' for Dates.

I realy could do with a bit of advise.


Thank you in Advance

 

[Kensan]

Your problem stems from the fact that you dont have references to the appropriate type libraries in your database.

If you open a code module then click the Tools/References menu option it will come up with a box showing you all the possible type libraries that your database can reference.

The problem you have is trying to figure out what libraries you need - you make a reference by ticking the check box at the LHS of the libraries you want to establish references for.

A safe bet would be to include Visual Basic For Applications - this is probably why it cant find the UCase and LCase functions which are part of the Visual Basic Library. If you're using Access '97 you probably want to also include the Microsoft DAO 3.51 Object Library as well as the Microsoft Access 8.0 Object Library. If your using Access 2000 you might be using ADO rather than DAO so you would want to include the ADO Libraries instead of the DAO one.

As for the rest it might be a case of trial and error until you can get your source code to compile.

There is also the possibility that someone may have created their own type library with custom objects. If this is the case you need to find a copy of this and install it - there will generally be an installation program for such a library as it needs to write to the Windows registry to register itself.

Yes it is a bit confusing and there are a lot of type libraries to choose from.

Hope this helps a bit

Good Luck