New string functions not recognised

[Guest]

Hello,

I am using an installation of MS Access 2000 on a different PC to my normal
PC. In a query, I use the function InSTRRev(), which I gather is relatively
"new". This function is not recognised in the alternative installation but
works fine on my normal PC. What could be wrong? I have checked the
References and they all look the same to me, but I might be missing something.

Operating system is Windows 2000 in both cases. Both MS Access
installations are version 9.0.4402 SR-1.

Obviously I can work around this, but it is annoying.

Any help appreciated.

Les Russell

 

[Allen Browne]

See:
http://support.microsoft.com/?id=225956

The k.b. article deals with problems with these functions: FormatCurrency(),
FormatDateTime(), FormatNumber(), FormatPercent(), InStrRev(), MonthName(),
Replace(), Round(), StrReverse() and WeekdayName()

 

[Guest]

Thanks very much - that has solved the problem.

See:
http://support.microsoft.com/?id=225956

The k.b. article deals with problems with these functions: FormatCurrency(),
FormatDateTime(), FormatNumber(), FormatPercent(), InStrRev(), MonthName(),
Replace(), Round(), StrReverse() and WeekdayName()

 

[David C. Holley]

That does it. I'm now utterly convinced there that the ID-10-T virus has
infected Redmond. (Maybe its time we apply the Racoon City solution to
them?) Why would you ever add a new function that doesn't support
expressions?