I developed an Access application that uses the Str(), InStr(), Left(),
Mid(), and Right() functions.  The application works fine on my machine but
on several others only the InStr() function works.  The Left(), Mid(),
Right(), and Str() functions can't be found.  (It gets the project or
library can't be found message.)

Can anyone please tell me what magic I'm missing?

Thanks in advance,
Steve Ireland

Hi,

This is a common problem that users might face whenever they upgrade from
Office 95 to Office 97. Sometimes, Access loses references to libraries
containing the definitions to above and other functions, giving you the
error message. Follow these steps to fix the error:

- Open a code module (any module, even a new one)

- Select Tools from the menu bar

- Select References.

- Uncheck any references that have the word 'Missing' tagged with

themselves (most usually utility.mda).

- Select Compile and Save all modules.

HTH

--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

Sounds like you are missing some Help files. Best cure is to do a reinstall
of Access (Office 97 if applicable).

Mike Self

Open one of your modules in Design view.  From the Access menu select Tools > References, and check
for any references beginning with the work "Missing".  Uncheck that (those) item(s), close the
module, and try your application elements that use the string functions again.

HTH,

That did it.  Thanks for your help John.

Steve