InSrtRev function error

[Steve S]

When I use the InSrtRev function on one pc I get the expected results. When
I run the very same code on another pc it get an error.

SQL
SELECT [TblC].[Name], InstrRev([Name]," ") AS [Length of Last Name]
FROM TblC;

Error
Undefined function in "InstrRev" expression.

Running Access 2000 (9.0.6926 SP-3) on both pcs
What am i missing here?

 

[Allen Browne]

This is a bug in Access 2000.

Create a little wrapper function to work around it.
Details:
http://support.microsoft.com/kb/225956

 

[Steve S]

Thanks much Allen

the function

Public Function fcnBackwards(strName As String, StrChar As String) As Byte
fcnBackwards = InStrRev(strName, StrChar, , vbTextCompare)
End Function

worked great
--
Steve S

This is a bug in Access 2000.

Create a little wrapper function to work around it.
Details:
http://support.microsoft.com/kb/225956

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

When I use the InSrtRev function on one pc I get the expected results.
When
I run the very same code on another pc it get an error.

SQL
SELECT [TblC].[Name], InstrRev([Name]," ") AS [Length of Last Name]
FROM TblC;

Error
Undefined function in "InstrRev" expression.

Running Access 2000 (9.0.6926 SP-3) on both pcs
What am i missing here?