Password Specific Switchboard

[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

 

[Guest]

Try having a condition like ---
objSysInfo.UserName = "YourUserName"
filling the logon name for "YourUserName"

 

[jvoss]

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

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!!!

 

[Allan Murphy]

Have a look at this site
http://forums.databasejournal.com/showthread.php?t=45488 goto message #10

I posted a sample login screen demo that opens a specific switchboard based
the users login and access level

Allan

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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.