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

CurrentDB.Execute strFunctionToRun

-- 
Stuart

On 14 Sep 2009 at 10:10, Darren - Active Billing wrote:

> 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