Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

Switchboard Buttons per user

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert_L_Ross - 07 Mar 2007 00:21 GMT
Is there any way to control the switchboard so that only specific users can
see a specific option on the switchboard?  For example, if the user is part
of the Admin group, they can see the switchboard option that opens the
Password Update page for all users, where a user who is part of the Users
group would see the button that opens up the password change form for their
own account only...or maybe control who can go to a submenu.

Right now I've created a form that looks just like the switchboard and I
have it check the CurrentUser() to determine when to display the Admin
Password Change form vs. the User Password Change form.  Can this be done via
the actual switchboard?
Damon Heron - 08 Mar 2007 18:09 GMT
It has been so long since I used a switchboard, I can't specifically answer
your question, but I would suggest that using a form as the startup form is
much more powerful and flexible, so why not do that instead?  You can set
the border to none on a form and add command buttons, submenus, exit
buttons, etc. that will address all of you concerns, and give you more
design options as well.

Just my 2 centavos worth.
Damon

> Is there any way to control the switchboard so that only specific users
> can
[quoted text clipped - 11 lines]
> via
> the actual switchboard?
Robert_L_Ross - 08 Mar 2007 21:41 GMT
Damon,

I have that now, but the problem is let's say User1 has rights to items 1,
2, 3 and 4, but User 2 only has rights to items 1, 3 and 4.  The problem is I
have to continually re-locate buttons on each form to keep the 'gaps' from
appearing.  The Switchboard automatically aligns buttons up to the top, so
I'd like to do it that way...plus, if I hand this DB off to somone else, they
may not be very code-savvy, so the easier the better.

> It has been so long since I used a switchboard, I can't specifically answer
> your question, but I would suggest that using a form as the startup form is
[quoted text clipped - 21 lines]
> > via
> > the actual switchboard?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.