run vba code from an acces form

[Stephan Gehrlein]

Hi,

I am planning a hidden administrative form in an access 2000 adp/ade
through which I could run vba functions or procedures just as I can
use them in the direct vba window in vba editor.
Thought about a textfield to put in the vba command an run it after
click on a cmd button:
e.g.: clsUser.Logon_user("username","Password","rolememb er"....)

But how do I execute this string in vba, so that I can use the form
for several functions or procedures even in an .ade??

Thanks for any suggestion and help
Stephan

[Trevor Best]

On 9 Sep 2003 08:07:07 -0700 in comp.databases.ms-access,
sg*******@sektor-n.de (Stephan Gehrlein) wrote:

Hi,

I am planning a hidden administrative form in an access 2000 adp/ade
through which I could run vba functions or procedures just as I can
use them in the direct vba window in vba editor.
Thought about a textfield to put in the vba command an run it after
click on a cmd button:
e.g.: clsUser.Logon_user("username","Password","rolememb er"....)

But how do I execute this string in vba, so that I can use the form
for several functions or procedures even in an .ade??

Dunno about class methods but if it's a public function you can use
Eval(), e.g. Eval("LogonUser(""username"",""password"")")

--
A)bort, R)etry, I)nfluence with large hammer.