If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Logon Script
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 |
Thread Tools | |
Display Modes | |
|
|