Undefined Function 'InStrRev' in Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 20 installs of WindowsXP at the office. On 19 of them, an application
works. One comes up with an error: Runtime 3805 - Undefined Function
'InStrRev' in expression. The location of the error is a query that has the
"InStrRev" function in a column. If I click the Build... wizard in the
column, to utilize the Expression builder, InStrRev is available from the
Functions > Built-In Functions > Text list.

I have tried to uninstall/reinstall the WindowsXP suite (using the complete
option), but the error still comes up.

Any thoughts?

Thanks,
DanishGuy
 
DanishGuy said:
I have 20 installs of WindowsXP at the office. On 19 of them, an
application works. One comes up with an error: Runtime 3805 -
Undefined Function 'InStrRev' in expression. The location of the
error is a query that has the "InStrRev" function in a column. If I
click the Build... wizard in the column, to utilize the Expression
builder, InStrRev is available from the Functions > Built-In
Functions > Text list.

I have tried to uninstall/reinstall the WindowsXP suite (using the
complete option), but the error still comes up.

Any thoughts?
Click to expand...

Check the references

Joerg
 
InStrRev is an unusual function. If checking your references
doesn't help, and other functions are OK, have a look at this
url:

About Microsoft Jet Expression Service sandbox mode
http://office.microsoft.com/en-us/assistance/HP010446591033.aspx

"The following is a list of things that might not work properly
if you enable sandbox mode before installing the latest Jet
service pack"

I am having this problem on some WinXP PC's. They DO have
the latest Jet service pack, and they DON'T have sandbox mode
enabled, so I haven't found a solution yet.

(david)
 
David:

I think the SandboxMode was the first step in clearing up this problem.
When I went into the 1 machine that is having this 'undefined' problem,
SandboxMode was set to '3' (All the other PCs are set to '2'). After
changing the setting to '2' and after reboot, I am still having the same
problem.

Maybe there is another security registry key that needs to be changed?

Info: Windows2K SP3
MS Access XP SP2

Thanks for your help so far. If I find a solution, I'll post it here. I am
willing to take suggestions too.


-Marc, DanishGuy
 
The only difference I have found so far between an XP box with
this problem and one without is the version of MSo9.dll: WinXP
updates KB885884 and KB834707. (I'm using Office 2K)
I don't have the opportunity to test that.
Maybe there is another security registry key that needs to be changed?
Click to expand...

Potentially, there might be 4 settings: an Office/Access setting
and a Jet setting, under HKey_Local_Machine and under HKey_Current_User.

(david)
 
Back
Top