how to call a function when name is in a variable

[Baldy]

really tricky one here.

I want to be able to call a function but the function name is in a variable.
The code is a security module that is querying a table that stores names of
functions, forms, reports etc and what access certain groups have. forms,
reports etc work fine as I use

DoCmd.OpenForm objectToRunName

but how do I do it when "objectToRunNam e" has a function name?

Thanks for any help
Alan

[Arno R]

Alan,
Do you mean that your objectToRunName comes from a function?

Dim strObject as string
strObject=YourF unction()
DoCmd.OpenForm strObject

--
Hope this helps
Arno R
"Baldy" <Jo**@smith.com > schreef in bericht news:41******** **@news.adelaid e.pipenetworks. com...

really tricky one here.

I want to be able to call a function but the function name is in a variable. The code is a
security module that is querying a table that stores names of functions, forms, reports etc and
what access certain groups have. forms, reports etc work fine as I use

DoCmd.OpenForm objectToRunName

but how do I do it when "objectToRunNam e" has a function name?

Thanks for any help
Alan

[Baldy]

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:41******** **************@ dreader2.news.t iscali.nl...

Alan,
Do you mean that your objectToRunName comes from a function?

Dim strObject as string
strObject=YourF unction()
DoCmd.OpenForm strObject

--
Hope this helps
Arno R
"Baldy" <Jo**@smith.com > schreef in bericht
news:41******** **@news.adelaid e.pipenetworks. com...

really tricky one here.

I want to be able to call a function but the function name is in a
variable. The code is a security module that is querying a table that
stores names of functions, forms, reports etc and what access certain
groups have. forms, reports etc work fine as I use

DoCmd.OpenForm objectToRunName

but how do I do it when "objectToRunNam e" has a function name?

Thanks for any help
Alan

[David Schofield]

On Thu, 7 Oct 2004 21:54:39 +0930, "Baldy" <Jo**@smith.com > wrote:

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

Hi
I have done this in vb6 but forgotten how.
However I see in the access97 help file (useful things) it says:

You can use the Eval function to evaluate an expression that results
in a text string or a numeric value.
You can construct a string and then pass it to the Eval function as if
the string were an actual expression. The Eval function evaluates the
string expression and returns its value. For example, Eval("1 + 1")
returns 2.
If you pass to the Eval function a string that contains the name of a
function, the Eval function returns the return value of the function.
For example, Eval("Chr$(65)" ) returns "A".
David

[Tom Mitchell]

Try:

Application.Run ObjectToRunName

Tom
"Baldy" <Jo**@smith.com > wrote in message news:<41******* ***@news.adelai de.pipenetworks .com>...

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:41******** **************@ dreader2.news.t iscali.nl...

Alan,
Do you mean that your objectToRunName comes from a function?

Dim strObject as string
strObject=YourF unction()
DoCmd.OpenForm strObject

--
Hope this helps
Arno R
"Baldy" <Jo**@smith.com > schreef in bericht
news:41******** **@news.adelaid e.pipenetworks. com...

really tricky one here.

I want to be able to call a function but the function name is in a
variable. The code is a security module that is querying a table that
stores names of functions, forms, reports etc and what access certain
groups have. forms, reports etc work fine as I use

DoCmd.OpenForm objectToRunName

but how do I do it when "objectToRunNam e" has a function name?

Thanks for any help
Alan

[user_5701]

What data type is your variable? I'm having a hard time trying to
figure out why you're doing it this way.

If this has something to do with security and access control, why not
just wrap the function call around an if statement?

if certainGroupsHa veAccess then
call accessGranted()
else
call accessDenied()
end if
"Baldy" <Jo**@smith.com > wrote in message news:<41******* ***@news.adelai de.pipenetworks .com>...

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:41******** **************@ dreader2.news.t iscali.nl...

Alan,
Do you mean that your objectToRunName comes from a function?

Dim strObject as string
strObject=YourF unction()
DoCmd.OpenForm strObject

--
Hope this helps
Arno R
"Baldy" <Jo**@smith.com > schreef in bericht
news:41******** **@news.adelaid e.pipenetworks. com...

really tricky one here.

I want to be able to call a function but the function name is in a
variable. The code is a security module that is querying a table that
stores names of functions, forms, reports etc and what access certain
groups have. forms, reports etc work fine as I use

DoCmd.OpenForm objectToRunName

but how do I do it when "objectToRunNam e" has a function name?

Thanks for any help
Alan

[Baldy]

David you are a true legend that is exactly what I want and it works a
treat.
Thanks
Alan

"David Schofield" <d.************ ***@blueyonder. co.uk> wrote in message
news:41656cb3.1 096326@localhos t...

On Thu, 7 Oct 2004 21:54:39 +0930, "Baldy" <Jo**@smith.com > wrote:

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

Hi
I have done this in vb6 but forgotten how.
However I see in the access97 help file (useful things) it says:

You can use the Eval function to evaluate an expression that results
in a text string or a numeric value.
You can construct a string and then pass it to the Eval function as if
the string were an actual expression. The Eval function evaluates the
string expression and returns its value. For example, Eval("1 + 1")
returns 2.
If you pass to the Eval function a string that contains the name of a
function, the Eval function returns the return value of the function.
For example, Eval("Chr$(65)" ) returns "A".
David

[Baldy]

Thanks Tom you are also a legend.

Both yours and Davids solutions work.

Alan
"Tom Mitchell" <rt*****@swbell .net> wrote in message
news:70******** *************** ***@posting.goo gle.com...

Try:

Application.Run ObjectToRunName

Tom
"Baldy" <Jo**@smith.com > wrote in message
news:<41******* ***@news.adelai de.pipenetworks .com>...

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:41******** **************@ dreader2.news.t iscali.nl...

> Alan,
> Do you mean that your objectToRunName comes from a function?
>
> Dim strObject as string
> strObject=YourF unction()
> DoCmd.OpenForm strObject
>
> --
> Hope this helps
> Arno R
>
>
> "Baldy" <Jo**@smith.com > schreef in bericht
> news:41******** **@news.adelaid e.pipenetworks. com...
>> really tricky one here.
>>
>> I want to be able to call a function but the function name is in a
>> variable. The code is a security module that is querying a table that
>> stores names of functions, forms, reports etc and what access certain
>> groups have. forms, reports etc work fine as I use
>>
>> DoCmd.OpenForm objectToRunName
>>
>> but how do I do it when "objectToRunNam e" has a function name?
>>
>> Thanks for any help
>> Alan
>>
>>
>
>

[Baldy]

Thanks but the problem is there could be thousands of condiftions as the
function being run's name is coming from a table and I need to be able to
add new names without re-writting the code.

Thanks but Tom and David actually had the solution.
Alan

"user_5701" <us*******@hotm ail.com> wrote in message
news:f1******** *************** ***@posting.goo gle.com...

What data type is your variable? I'm having a hard time trying to
figure out why you're doing it this way.

If this has something to do with security and access control, why not
just wrap the function call around an if statement?

if certainGroupsHa veAccess then
call accessGranted()
else
call accessDenied()
end if
"Baldy" <Jo**@smith.com > wrote in message
news:<41******* ***@news.adelai de.pipenetworks .com>...

Hi Arno

No

the value in objectToRunName is name of the function I want to run.

Thanks for your response
Alan

"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:41******** **************@ dreader2.news.t iscali.nl...

> Alan,
> Do you mean that your objectToRunName comes from a function?
>
> Dim strObject as string
> strObject=YourF unction()
> DoCmd.OpenForm strObject
>
> --
> Hope this helps
> Arno R
>
>
> "Baldy" <Jo**@smith.com > schreef in bericht
> news:41******** **@news.adelaid e.pipenetworks. com...
>> really tricky one here.
>>
>> I want to be able to call a function but the function name is in a
>> variable. The code is a security module that is querying a table that
>> stores names of functions, forms, reports etc and what access certain
>> groups have. forms, reports etc work fine as I use
>>
>> DoCmd.OpenForm objectToRunName
>>
>> but how do I do it when "objectToRunNam e" has a function name?
>>
>> Thanks for any help
>> Alan
>>
>>
>
>

[Lyle Fairfield]

"Baldy" <Jo**@smith.com > wrote in news:4165ae71$1 _1
@news.adelaide. pipenetworks.co m:

Thanks but the problem is there could be thousands of condiftions as the
function being run's name is coming from a table and I need to be able to
add new names without re-writting the code.

Thanks but Tom and David actually had the solution.

This is utter bunk. User_9999 gave you some good advice. Although Microsoft
seems happy in confusing data and instructions it is a very bad idea to do
so.

BTW no one becomes a legend because he or she knows some trivial bit of code.

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.