Password Specific Switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a couple of switchboards set up for different sets of users.
Depending on login used, is there a way to open a specific switchboard?

Any help is appreciated.
Thanks,
Pam
 
Try having a condition like ---
objSysInfo.UserName = "YourUserName"
filling the logon name for "YourUserName"
 
Hi,

I have a couple of switchboards set up for different sets of users.
Depending on login used, is there a way to open a specific switchboard?

Any help is appreciated.
Thanks,
Pam
Click to expand...

Hi pam,
i have found on the inter net that allows you to do what. how ever
can't remember where i saw it. i do how ever have a copy i can place
give you. this data base is simple to adjust to your application.

jody
access the great unknow!!!
 
Karl,

Thank you for replying. Can you please explain using this condition in
further detail. I have a secured front and back end database and it uses the
Access security login form and I was hoping to set up something with this
login so that a user would have a specific switchboard to open when they
logged in. I'm not sure what I'm to do with the code you supplied.

Again, thank you for your time.
Pam
 
Allan,

Thank you for replying. I looked at your sample and it looks to be set up
for a custom login screen. I'm using the one from the Access security. If
this will still work, would you mind explaining how?

Thanks for your time.
Pam
 
I have not tried this but you would create a macro named Autoexec that would
run upon opening the database. When creating the macro click on menu VIEW -
Conditions. Use the condion substituting the users logon. Use action
OpenForm and the specific switchboard for that person. In the next row put
three periods in the condition ( ... says to apply the same condition as
above) and action StopAllMacros.

Add a new line for next with their logon and switchboard name and next row
put three periods in the condition with action StopAllMacros.

End with opening a generic switch board.
 
Back
Top