Logon Script

I'd like to "personalize" logons. How can I execute a script or a series of
subroutines based on a user's ID (Not the Access USERID...I have my own login
security, etc.) I'd like to set the user's "login type", and have the system
execute a series of instructions based on that login type, preferrably a set
of instructions located in a table entry...

Basically, I'm asking if it's possible to have a column in a table hold an
instruction (like maybe a subroutine name, for example, or a macro name if
you will...) and execute it in vba....

Techninques you've used?
--
Jim

If your application has a form identified in the Start Up options, put the
code in the After Update of the control where the user enters the password
which whould be after the user enters the login name. Then when they enter
the password and it is verified, the code will run to perform your login
tasks. You can use the name of a macro stored in a table field and you can
use the Eval function to run a VBA procedure.
--
Dave Hargis, Microsoft Access MVP


"JimS" wrote:

I'd like to "personalize" logons. How can I execute a script or a series of
subroutines based on a user's ID (Not the Access USERID...I have my own login
security, etc.) I'd like to set the user's "login type", and have the system
execute a series of instructions based on that login type, preferrably a set
of instructions located in a table entry...

Basically, I'm asking if it's possible to have a column in a table hold an
instruction (like maybe a subroutine name, for example, or a macro name if
you will...) and execute it in vba....

Techninques you've used?
--
Jim