How do I reference a VBA procedure from Access Macro Definition?

[Guest]

I have created a number of VBA functions in an Access database and am trying
to use them in a macro. I have tried RunCode, OpenStoredProcedure, among
others, but Access can't seem to find any of my functions. I have them placed
in a module and a static class module but none are there. All are declared as
Public.

If I use Expression Builder for RunCode, I can find it, but I get an error
message when I try to run it: "The expression you entered has a function name
that Microsoft Access can't find."
If I use OpenStoredProcedure, I get an empty list in the "Procedure Name"
property selector at the bottom.

Please help

 

[Steve Schapel]

VanTek,

RunCode is the applicable action in your macro. In the Function Name
argument, you should have the name of the function followed by empty
parentheses, for example...
KillFred()

Another thing to note is that the name of the Module that contains the
function must not be the same as the name of the function.

Let us know.