Next: Vlookup In Access
From: Karen on 11 Feb 2005 11:21
I'm trying to use InstrRev in a query but its not being recognised. I get an
undefined function message when I try and run the query. Any ideas?

Karen
From: "Brendan Reynolds" <brenreyn at indigo dot on 11 Feb 2005 11:35
Which version of Access? InStrRev should work in Access 2003. It did not
work in queries in the original release of Access 2000. You *may* be able to
get it to work in queries in Access 2000 by installing the latest service
releases for Office and Jet, if you have not already done so. Failing that,
you can write a custom VBA function that calls InStrRev, and call the
function from your query.

--
Brendan Reynolds (MVP)


"Karen" <Karen(a)discussions.microsoft.com> wrote in message
news:06C976E7-A241-4D58-9F93-1B06D0C8A934(a)microsoft.com...
> I'm trying to use InstrRev in a query but its not being recognised. I get
> an
> undefined function message when I try and run the query. Any ideas?
>
> Karen


From: Karen on 11 Feb 2005 12:05
Thankyou. Written a function which works perfectly.

Karen

"Brendan Reynolds" wrote:

> Which version of Access? InStrRev should work in Access 2003. It did not
> work in queries in the original release of Access 2000. You *may* be able to
> get it to work in queries in Access 2000 by installing the latest service
> releases for Office and Jet, if you have not already done so. Failing that,
> you can write a custom VBA function that calls InStrRev, and call the
> function from your query.
>
> --
> Brendan Reynolds (MVP)
>
>
> "Karen" <Karen(a)discussions.microsoft.com> wrote in message
> news:06C976E7-A241-4D58-9F93-1B06D0C8A934(a)microsoft.com...
> > I'm trying to use InstrRev in a query but its not being recognised. I get
> > an
> > undefined function message when I try and run the query. Any ideas?
> >
> > Karen
>
>
>
 | 
Pages: 1
Next: Vlookup In Access