Public Function Problem (1 Viewer)

david_johnson_CR

New member
Local time
Today, 09:10
Joined
Dec 5, 2017
Messages
7
Greetings!

I'm trying to use code designed by Allen Browne. I've followed his instructions (I'm pretty sure) on how to use the code and setting up the function. When I get into the query and when I type in "concatrelated" it even offers the tiny box that shows all the variables I need to enter as with the standard Access functions. I type them in but when I try to run the query I get "Undefined Function 'ConcatRelated' in Expression". I'm not sure if there's a step I'm skipping but it seems to recognize the function until I actually try to execute.

Is there something specific I have to do to "enable" public, user-defined functions?

Thanks so much for any help you all can provide!!
 

CJ_London

Super Moderator
Staff member
Local time
Today, 15:10
Joined
Feb 19, 2013
Messages
16,605
nothing specific - it needs to be a public function in a standard module (not a form module). Suggest post the full sql to your query
 

Minty

AWF VIP
Local time
Today, 15:10
Joined
Jul 26, 2013
Messages
10,371
Also don't call the Module you saved it in ConcatRelated, as that will break things.
Call it something like modFunctions or similar.
 

Users who are viewing this thread

Top Bottom