[AccessD] A2K: Run a VBA Function whose name is stored in a table

Hi Darren,

You can use

Application.Run strFunctionToRun

You can also pass parameters if your function has some - read about
Application.Run method in MS Access online help.

--Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active
Billing
Sent: Monday, September 14, 2009 4:11 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2K: Run a VBA Function whose name is stored in a table

Hi Team

 

How do you 'run' a VBA function in my Access dB whose name is stored in a
table?

 

Say I have a table called tblFunctions with 3 fields 

Fieldnames are : FunctionID, IsToRun and FunctionName

The 1st Field = PK, 2nd field = Integer and 3rd = text

 

EG

 

Dim strFunctionToRun as string

 

strFunctionToRun = dlookup("[FunctionName]","tblFunctions", "IsToRun = -1")

 

Assume the results of strFunctionToRun is
say."f_SomeCoolFunctionThatDoesStuff"

 

How do I 'run' the results of strFunctionToRun??

 

IE how do I run "f_someCoolFunctionThatDoesStuff"

 

Many thanks in advance

 

DD

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4422 (20090913) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4422 (20090913) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru