Run a sub-routine using a string variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I build a string variable and use its name to run a sub-routine.

For Exapample:

strProcess = "Run_Process_" & strDB

strDB = DB2
Subroutine name = Run_Process_DB2()

Your help is appreciated.

Ross
 
Hi, Ross.
How can I build a string variable and use its name to run a sub-routine.
Click to expand...

Use the CallByName( ) function for a procedure in a form's module or use the
Application.Run( ) function for a public function in a standard module. For
example:

CallByName Me, strProcess, VbMethod ' Run sub in form or report.
Application.Run strProcess ' Run sub in module.

The called procedure must be public, not private, even if it's called from
the same form.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
You're welcome! Glad it helped.

Please consider helping others who have the same question by signing in to
the Microsoft Online Community and marking my earlier post as the answer to
your question. That way, others who have the same question can search the
database for answered questions and instantly find it, without having to post
the same question you did and then wait around for hours or days until
someone answers it.

Thanks!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
 
Back
Top