Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String functions do not work anymore in VBA used in MS Access under NT

Status
Not open for further replies.

Josmaarten

Programmer
Mar 22, 2002
4
GR
Hello,

I have an application in MS Access (Office 97).
It uses the Right$, Left$ and Mid$ functions and works fine on several PCs.
On two PCs running NT4, SP6 these String functions do not work. The application aborts with the message
" function or library not found"
Any idea?
Thanks,
Josmaarten Swinkels
 
You are referencing a library that doesn't exist or can't be found on that NT machine. Remove or fix the offending reference.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"
 
Thanks, but it used to work before. I am sure about that.
So it looks like the library is missing, but how do I find out which library it is and how do I add it?
 
Open a code window, go to Tools:References. You will see one that says 'Missing'. If you don't need that reference remove it. If you need it you will have to fix the reference by installing the needed file on that computer and then creating a reference to it.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top