Run Code passing arguments from switchboard

[Guest]

Using Access 2003, is there some way to pass arguments to a function when
using the Run Code Command from the built in switchboard?

thanks
James

 

[Larry Linson]

As far as I know, there is no "Run Code Command" -- there is a RunCode
action on macros. Perhaps you could clarify and be explicit about what you
are doing and the code that is involved.

Many of us do not use the Switchboard Manager because it is a complex
solution to a simple problem and, obviously, just judging from questions in
the newsgroups, causes a great many problems.

If you create your own switchboard using unbound form(s), command buttons,
and VBA code in the click event, you have full control over what you do.

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry,
using the built-in switchboard (Tools>Database Utilities>Switchboard Manager)
Edit a switchboard item. In the command box, the bottom option is 'Run Code'
which calls a function in a module. I would like to pass the function some
arguments. I am doing so by calling an intermediate function whose sole
purpose is to call the function I want and pass it the appropriate arguments.
It would be cleaner if I could pass arguments from the built in switchboard.

James Deckert