call a module from a switchboard item?

[Guest]

With lots of help from Ken Snell & Doug Steele in the General Questions
Forum, I was able to create a module that lets the users choose a file for
import. The module is the api calls from
http://www.mvps.org/access/api/api0001.htm It contains a number of
functions, at the end of which I added my own that actually does the
TransferSpreadsheet method.
If I put the module in design mode and then run the function I created (with
F5) the transfer completes as desired.
My question is: how do I put this on a switchboard item so it can be run by
a user?
I have tried using the name of the module, the name of the function and even
changed it to a sub, and used that but it does not run. Additionally, it
comes up with the "Enter Parameter Value", and I can enter 0 and it still
won't run.
This seemed like a Newbie question, so I thought I should post it here.
Thanks for any help offered!

 

[Albert D. Kallal]

Probably the easy way is to have the switchboard launch a nice form with a
button on to run the code.

I often use all kinds of "prompt" forms that don't edit data..but just have
button on them. Here is some screens shots of forms that don't edit
data..but just ask the user things:

http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

 

[Guest]

Of course! thank you!