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

M

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.
 
V

Vincent Johns

masterminx said:
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.
 
M

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!
 

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