Can't find libary error

[zp162002]

Hello All,

I am having trouble using Access 97. When compiling a module containing the following line of code,

strFirstName = Right(strFullName, intFullNameLength - intCommaPosition)

I receive the following error message:

Compile Error
Can't Find Project Or Library.

When I click ok, the system highlights the word "Right".

After examining the object library, I have determined the libary for the right function is called "Visual Basic For Applications." Which is located in C:\Program Files\common Files\Microsoft Shared\VBA\VBA332.dll.

Does anyone have an idea as to what is causing this error?

 

[PHV]

Seems like a missed or broken reference in the VBA project.
When in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[zp162002]

I can open the References window without any difficulty.

Do you suggest reinstalling Access?

 

[PHV]

And no MISSING reference ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[zp162002]

The reference window opens right up.

I put the module in a new database on it worked fine.