JET error: undefined function "InStrRev"

  • Thread starter Thread starter michele
  • Start date Start date
M

michele

Hi all,
i'm using a query in my database that calls the function InStrRev;
the query work fine in Access, but if i try to access it using Microsoft Jet
(from an external app), i receive the error:

undefined function "InStrRev"

Is there a solution?
Thanks
 
InStrRev is a VBA function. Jet doesn't know about most VBA functions.
There's no real workaround other than using Access Automation, which isn't
always possible.
 
So how to use Access Automation?
Thanks,
Michele

Douglas J. Steele said:
InStrRev is a VBA function. Jet doesn't know about most VBA functions.
There's no real workaround other than using Access Automation, which isn't
always possible.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InstrRev error 4
InSrtRev function error 2
InstrRev 2
Undefined Function Replace and InStrRev 2
[Microsoft][ODBC Microsoft Access Driver] Invalid procedure call 1
Built-In Functions 6
Finding the space in a text string and returning text on either si 8
Access #Error & Excel Pivot 0

Back
Top