What is the syntax for function name in run code switchboard mgr?

[masterminx]

I have converted all of my macros to modules and I want some of them to
launch from my switchboard. I am guessing I need to use the Run Code option
in Switchboard manager, but I don't know the syntax needed in the Function
Name box, there.

 

[Vincent Johns]

I have converted all of my macros to modules and I want some of them to
launch from my switchboard. I am guessing I need to use the Run Code option
in Switchboard manager, but I don't know the syntax needed in the Function
Name box, there.

As with a "RunCode" action in a Macro, you'll (probably, but Access Help
wasn't too specific) need to define a public function to be called. In
the Switchboard Manager, set the value of "Function Name:" to the name
of the function, with no parentheses.

Incidentally, there may be no compelling reason to get rid of all your
Macros; occasionally they are more convenient than functions are in
Modules to define and are not difficult to use, even though what they
can do is limited.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[masterminx]

Thank you, sir. I discovered the answer to this one by digging about last
night. In the case of converted macros, one only has to change the command
from 7 to 8 in the Switchboard Items table, and make sure any spaces are
changed to underscores. Silly that it doesn't explain that in the Help file.


Thanks!