How to Run a VB Module from a Macro



How do you run a VB module from a macro in Access 97? The only option I see
in the the macro is to open a module.





Brendan Reynolds

You don't run a module, you run a procedure (a sub or a function, but as far
as I am aware only functions can be run from macros). A module is just a
container used to organise your procedures. You can run a function from a
macro using the RunCode action.

Brendan Reynolds (MVP)

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


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