InStrRev available in Access 2000?

[willybgw]

I am getting undefined function error when trying to use InStrRev in Access 2000. Shouldn't this function be available?

willybgw

 

[Melagan]

if I type instrrev in immediate window then hit f1, there are help files for instrrev. Are you debugging your code and getting a break with your instrrev function? if not, where?

~Melagan
______
"It's never too late to become what you might have been.

 

[willybgw]

Hi Melagan. In query design view I am making a field using instrrev when I run the query I get the error. What are you referring to as immediate window?

willybgw

 

[Melagan]

if you hit ctrl-g anywhere in access, it will pull up your VB editor with the immediate window in focus; it's a place where you can test functions and code.

How about pasting in your SQL ?

~Melagan
______
"It's never too late to become what you might have been.

 

[willybgw]

What I am doing now is just a test. This is all there is to the SQL.

SELECT InStrRev([ADDRESS]," ") AS X
FROM SALES;

willybgw

 

[Melagan]

In Access 2k I did the following, using "1234 Main Street" as a test:

SELECT Instrrev([address], " ") as X
FROM Sales

it accurately returned a value of 10.

Perhaps you're missing a reference ? I'm not sure which library InStrRev is in for sure, but I'd assume it was in VBA or in msacc09.olb.

My Access 2k references are:
Visual Basic for Applications
Microsoft Access 9.0
OLE Automation
Microsoft ADO 2.1

~Melagan
______
"It's never too late to become what you might have been.

 

[willybgw]

Melagan - thanks for your efforts. I am going to try this on my home computer tonight. I think there may be an installation
issue.

If I go into expression builder, built-in-functions instrrev is not in the list.

willybgw