hellblazeruk
asked on
Macro to run a module from Microsoft Access
I have been searching but can’t find how to do this, how do I run a module from a macro in Access?
You use the "RunCode" action and note that the procedure called needs to be a function (return a value - doesn't matter what, just that it does).
Jim.
Jim.
ASKER
This the access db, I would like to run the module in this file
POSSales.accdb
POSSales.accdb
Again, you don't run 'Modules'. Modules contain either Functions or Sub. Functions return a value and Subs do not. In a Macro, you can only run a Function (see screen shot above).
mx
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
You can run code that's in a module.
Is that what you want to do?