Re: InstrRev error
- From: "david" <david@xxxxxxxxx>
- Date: Sat, 15 Nov 2008 14:49:25 +1100
The second PC may not have macro security set up the same way.
The second PC may not have service packs installed the same way.
Those are the official reasons, but I decided that it was unreliable,
and I when back to using a User Defined function for InstrRev.
InstrRev was a VB function that was only added to Access VBA
in Access 2000.
There was a list of VBA functions that the query environment
recognises. Unfortunately, the new function InstrRev was left
off of the list, and didn't work in Access 2000 queries.
Fortunately, it was added to the list later.
Later, there was a list of safe expressions that you can use in a query.
Unless you allow unsafe expressions, you can't use unsafe expressions.
Unfortunately InstrRev seemed to have an indeterminate status after
the 'safe expression' list came out, and worked on some machines
and not on others.
You can try to track down this problem, but I wouldn't bother:
you'll have to check it again on every PC you ever use.
Don't use InstrRev in a query. Use a user defined function.
(david)
"Steve S" <SteveS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DB8A849E-5940-40CF-9856-464A7D15BFCE@xxxxxxxxxxxxxxxx
When I run the following query on one pc I get the expected results.
SELECT [TblC].[Name], InstrRev([Name]," ") AS [Length of Last Name]
FROM TblC;
But when I run the very same query on another pc I get the error:
Undefined function "InstrRev" in expression.
Both pcs are running Access 2000 (9.0.6926 SP-3)
What am I missing here
--
Steve S
.
- Follow-Ups:
- Re: InstrRev error
- From: Steve S
- Re: InstrRev error
- References:
- InstrRev error
- From: Steve S
- InstrRev error
- Prev by Date: Re: Insert query from Access 97 to 2002
- Next by Date: RE: reconcile related tables
- Previous by thread: Re: InstrRev error
- Next by thread: Re: InstrRev error
- Index(es):
Relevant Pages
|
