Acces-"Unrecognized function name" using fn in query. ok pre-2003

G

Guest

I'm using a user-defined function for a search criteria in a query. After
upgrading clients to 2003, I get "Unrecognized function name" when I try to
run it. The function is public and it should see it. It even shows up in
the list when I use the Build window. Please help. Thanks in advance.
 
J

Jeff Boyce

There's a chance one of your References is marked "MISSING". Open a module,
click Tools|References and check. If any are, uncheck them, close/save,
then re-open and re-check. Re-compile.

Regards

Jeff Boyce
<Office/Access MVP>
 
D

david epsom dot com dot au

You may have "macro security" set to prevent user defined functions
in queries.

(david)
 
G

Guest

Thanks Jeff. That was definitely something to check. Hadn't thought of it.
They were all ok. David nailed it. Macro Security was set on medium (by
default i guess). Changed it to Low and it worked.

Jason
 
G

Guest

That was it. Thanks a lot!

Jason

david epsom dot com dot au said:
You may have "macro security" set to prevent user defined functions
in queries.

(david)
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

Use In() Expression as Query criteria with guts from Function 1
The PROPER function 1
Optional Variables in Functions (REPLACE and other 'Worksheet' functions) 2
IF function in Query 2
Can I call a function in query criteria? 4
Sudden problem with functions in queries 2
Date Function not working in queries or on Forms 2
Cannot use function in query 1

Top