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

  • Thread starter VanTek Data Services
  • Start date
V

VanTek Data Services

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
 
S

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.
 

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