Undefined function 'xxxx' in expression

G

Gab Opadokun

I have created a custom function and referenced same from
a query. The query terminates with the message "Undefined
function 'xxxx' in expression" displayed each time I
attempt to run the query.
 
K

Ken Snell [MVP]

The custom function must be put in a regular module (a module seen in the
"Modules" window of the database window), the module name must be a name
different than the function name, and the function must be a Public
function.
 
S

StCyrM

Good morning

Can you post the SQL statement?


Maurice St-Cyr
Micro Systems Consultants, Inc.
 
G

Gab Opadokun

Thank you
-----Original Message-----
The custom function must be put in a regular module (a module seen in the
"Modules" window of the database window), the module name must be a name
different than the function name, and the function must be a Public
function.

--

Ken Snell
<MS ACCESS MVP>




.
 

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

Top