Undefined function in Query

[ggrewe]

I have searched for this problem and found several postings that tell me to open the VBE and then check "Tools, References" to make sure the right libraries are added, but I still have the same problem with this query. I cannot determine what libary is missing. I am running Access 2003. Any help is greatly appreciated.

Here are the libraries that I have listed:
1. VBA
2. MS Access 11.0 Object Library
3. OLE Automation
4. MS DAO 3.6 Object LIbrary
5. MS Active x Data Object 2.1 Library


I am trying to split the first and last name from one field in someone's table, which is in the format: "GREWE, GREG"

SELECT MID([INDV-NAME],1, INSTR(1, [INDIV-NAME], ",")) AS lastname FROM TABLE ORDER BY FIELD NAME

The error message is Undefined Function MID.

thanks



Greg Grewe
West Chester, Ohio

 

[antvon]

Hi Greg

I have had the same problem on Acc 2000 with the Left
Function. The references were correct in my case as well.

The funny thing is that the app works fine on a win95 machine and winXP but gives the error on a win2k and win98
machines.(the combination may be swopped around i'm not sure anymore).What doesn't make any sense is that all the
machines had acc 2000 installed.

I had managed to get one of them to work by copying the
referenced dll from a working version to the client pc.
This resolved the issue on that machine.

I suspect that the dll version may have something to do
with it.It's not much I know but I hope it helps.At the
very least you'll know you not alone.

Anton

 

[ggrewe]

Thanks Anton, I will try that. Have a good weekend.



Greg Grewe
West Chester, Ohio