I'm new to Access and VBA, so please bear with me. (I'm a 'C' programmer)
I'm using Access 2010 and created a module with VBA called "XXXXX" (not it's real name) and the module contains one function of the same name. In Query design mode, I can click on functions and find it, but when I try to run the query, I get the error msg: "Undefined function 'XXXX' in expression. In reading other postings, I have tried the references issue and that doesn't apply.
What am I doing wrong?
I'm using Access 2010 and created a module with VBA called "XXXXX" (not it's real name) and the module contains one function of the same name. In Query design mode, I can click on functions and find it, but when I try to run the query, I get the error msg: "Undefined function 'XXXX' in expression. In reading other postings, I have tried the references issue and that doesn't apply.
What am I doing wrong?