Run Code Switchboard Command

G

Guest

What is the format for identifying the code to use in a Run Code Switchboard
Command? I have several procedures that I can only get the switchboard to
call by setting up macros to call them and using the Switchboard Run Macro
Command. This seems rather silly to me, but whenever I try to use Run Code
and put in the name of a public function, I get a message that Access cannot
find the function. I am using Access 2003, but the database was originally
set up in Access 2000 if that makes any difference.
 
A

adsl

Amy Baggott said:
What is the format for identifying the code to use in a Run Code
Switchboard
Command? I have several procedures that I can only get the switchboard to
call by setting up macros to call them and using the Switchboard Run Macro
Command. This seems rather silly to me, but whenever I try to use Run
Code
and put in the name of a public function, I get a message that Access
cannot
find the function. I am using Access 2003, but the database was
originally
set up in Access 2000 if that makes any difference.
Click to expand...
 
A

adsl

Amy Baggott said:
What is the format for identifying the code to use in a Run Code
Switchboard
Command? I have several procedures that I can only get the switchboard to
call by setting up macros to call them and using the Switchboard Run Macro
Command. This seems rather silly to me, but whenever I try to use Run
Code
and put in the name of a public function, I get a message that Access
cannot
find the function. I am using Access 2003, but the database was
originally
set up in Access 2000 if that makes any difference.
Click to expand...
 
A

adsl

Amy Baggott said:
What is the format for identifying the code to use in a Run Code
Switchboard
Command? I have several procedures that I can only get the switchboard to
call by setting up macros to call them and using the Switchboard Run Macro
Command. This seems rather silly to me, but whenever I try to use Run
Code
and put in the name of a public function, I get a message that Access
cannot
find the function. I am using Access 2003, but the database was
originally
set up in Access 2000 if that makes any difference.
Click to expand...
 
G

Guest

These are functions I wrote. The functions work fine, but the Switchboard
doesn't want to admit they exist.
 
G

Guest

I've tried it both with and without. I can call the functions fine from a
macro or from another VBA code procedure. It's only the Switchboard that's
being picky.
 
F

fredg

These are functions I wrote. The functions work fine, but the Switchboard
doesn't want to admit they exist.
Click to expand...

Is the function placed in a Module?
Open your Switchboard Items table.
The RunCode command value is 8.
Find the record with the Switchboard number and command button number
you want to use. Enter an 8 as the command value for that record then
write the name of the sub procedure in that record's Argument field.
Do not include an = sign.

SwitchboardID ItemNumber ItemText Command Argument
1 3 ButtonCaption 8 RunUpdateQuery
 
G

Guest

That worked. I wonder why it worked typing it directly into the table when
it wouldn't work typing it into the wizard?
 

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

Similar Threads

Access Switchboard error message 1
How Do I Specify the Code to Run on a Switchboard Run Code Command 4
Switchboard Minimized 4
switchboard problem 4
SWITCHBOARD 1
Controlling another switchboard 2
Access not closing using Switchboard form 3
SWITCHBOARD MANAGER 7

Top