Built-In Functions

[Rick]

I am attempting to create an expression that contains built-in functions such
as InStrRev but I keep getting an "undefined function (3085)" error. How do I
get Access to recognize the built-in functions that are available in the
expression builder? Thanks for your assistance.

 

[Allen Browne]

If this is Access 2000, this article addresses the problem:
http://support.microsoft.com/kb/225956

If not, there might be a problem with references:
http://allenbrowne.com/ser-38.html

 

[Rick]

I am creating an expression in a query. The solution for Access 2000 applies
to forms. Is there also a solution for queries? Thanks for your assistance.

 

[Allen Browne]

The solution in the kb is for queries.

You need to create wrapper function in a standard module, and then use this
function in your query instead of built-in one.

 

[Rick]

I have seen Visual Basic but have not used it extensively. I did a Ctrl-G
which took me to Visual Basic but I saw no way of creating a module/function
on the menu toolbar. Most of the selections were grayed out and the VB window
was empty and did not already contain any modules/functions. The sample
function seemed simple enought if I can get to the place where I have a
module/function in which to create it. Thanks for your assistance.

 

[Allen Browne]

Click the Modules tab of the Database window, and click New.
Access opens a new code window.

Put the code in there.
Choose Compile on the Debug menu, to ensure Access understands it.

Save the module with a name such as Module1.

You can now use the function in your query.

 

[Rick]

Works like a champ. Thanks very much for your assistance.