|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Load Form Based on Current User's GroupI have a Timesheet application for which I will be using Security for the
first time. Most users will have read/edit permissions for a single form, by which they enter their time spent on various projects. I would like to load an Administration Menu form on startup for those in the Admins group, and the Timesheet form for the Users. Prior to securing the database, I've set the Adminstration Menu as the form to load on startup, and used a DLookup call in the Form_Open event to determine the value of a stored "FullAdminRights" field for the current user. If the user doesn't have the rights, the form closes and the Timesheet form opens. I'd rather let Security handle this, but if I remove User permissions for the Administration Menu form, will the Form_Open event procedure even run? If not, how can I load the Timesheet form? Thanks for all help. Sprinks Read the Security FAQ for the UserInGroup function. You button for opening
your forms could, then be something like this If UserInGroup("Admins") then Open Administration menu form Else Open Timesheet form End if -- Show quoteHide quoteLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html "Sprinks" <Spri***@discussions.microsoft.com> wrote in message news:92C02700-758C-47E6-8223-D512B7F2ECB4@microsoft.com... >I have a Timesheet application for which I will be using Security for the > first time. Most users will have read/edit permissions for a single form, > by > which they enter their time spent on various projects. I would like to > load > an Administration Menu form on startup for those in the Admins group, and > the > Timesheet form for the Users. > > Prior to securing the database, I've set the Adminstration Menu as the > form > to load on startup, and used a DLookup call in the Form_Open event to > determine the value of a stored "FullAdminRights" field for the current > user. > If the user doesn't have the rights, the form closes and the Timesheet > form > opens. > > I'd rather let Security handle this, but if I remove User permissions for > the Administration Menu form, will the Form_Open event procedure even run? > If not, how can I load the Timesheet form? > > Thanks for all help. > Sprinks Thanks, Lynn.
How could I have this code execute on opening the database? I thought of putting it in another form, set as the default to open, but I'd think there'd be a cleaner way. Thank you. Sprinks Show quoteHide quote "Lynn Trapp" wrote: > Read the Security FAQ for the UserInGroup function. You button for opening > your forms could, then be something like this > > If UserInGroup("Admins") then > Open Administration menu form > Else > Open Timesheet form > End if > > -- > Lynn Trapp > MS Access MVP > www.ltcomputerdesigns.com > Access Security: www.ltcomputerdesigns.com/Security.htm > Jeff Conrad's Access Junkie List: > http://home.bendbroadband.com/conradsystems/accessjunkie.html > > > > "Sprinks" <Spri***@discussions.microsoft.com> wrote in message > news:92C02700-758C-47E6-8223-D512B7F2ECB4@microsoft.com... > >I have a Timesheet application for which I will be using Security for the > > first time. Most users will have read/edit permissions for a single form, > > by > > which they enter their time spent on various projects. I would like to > > load > > an Administration Menu form on startup for those in the Admins group, and > > the > > Timesheet form for the Users. > > > > Prior to securing the database, I've set the Adminstration Menu as the > > form > > to load on startup, and used a DLookup call in the Form_Open event to > > determine the value of a stored "FullAdminRights" field for the current > > user. > > If the user doesn't have the rights, the form closes and the Timesheet > > form > > opens. > > > > I'd rather let Security handle this, but if I remove User permissions for > > the Administration Menu form, will the Form_Open event procedure even run? > > If not, how can I load the Timesheet form? > > > > Thanks for all help. > > Sprinks > > > May be a better way, but sometimes I set my database to load up to a form
dedicated to routing users to the proper form. It has a script similar to the one Lynn posted set to the Open event, and closes as soon as that script runs. Have the startup form open invisible and in the Open event of that form run
the code to either open the administrator form or the Time entry form. -- Show quoteHide quoteLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html "Sprinks" <Spri***@discussions.microsoft.com> wrote in message news:DDC4245E-D4F5-45BA-B2E0-5A25BC472B44@microsoft.com... > Thanks, Lynn. > > How could I have this code execute on opening the database? I thought of > putting it in another form, set as the default to open, but I'd think > there'd > be a cleaner way. > > Thank you. > Sprinks > > "Lynn Trapp" wrote: > >> Read the Security FAQ for the UserInGroup function. You button for >> opening >> your forms could, then be something like this >> >> If UserInGroup("Admins") then >> Open Administration menu form >> Else >> Open Timesheet form >> End if >> >> -- >> Lynn Trapp >> MS Access MVP >> www.ltcomputerdesigns.com >> Access Security: www.ltcomputerdesigns.com/Security.htm >> Jeff Conrad's Access Junkie List: >> http://home.bendbroadband.com/conradsystems/accessjunkie.html >> >> >> >> "Sprinks" <Spri***@discussions.microsoft.com> wrote in message >> news:92C02700-758C-47E6-8223-D512B7F2ECB4@microsoft.com... >> >I have a Timesheet application for which I will be using Security for >> >the >> > first time. Most users will have read/edit permissions for a single >> > form, >> > by >> > which they enter their time spent on various projects. I would like to >> > load >> > an Administration Menu form on startup for those in the Admins group, >> > and >> > the >> > Timesheet form for the Users. >> > >> > Prior to securing the database, I've set the Adminstration Menu as the >> > form >> > to load on startup, and used a DLookup call in the Form_Open event to >> > determine the value of a stored "FullAdminRights" field for the current >> > user. >> > If the user doesn't have the rights, the form closes and the Timesheet >> > form >> > opens. >> > >> > I'd rather let Security handle this, but if I remove User permissions >> > for >> > the Administration Menu form, will the Form_Open event procedure even >> > run? >> > If not, how can I load the Timesheet form? >> > >> > Thanks for all help. >> > Sprinks >> >> >> Thank you Lynn and DJ.
Sprinks Show quoteHide quote "Lynn Trapp" wrote: > Have the startup form open invisible and in the Open event of that form run > the code to either open the administrator form or the Time entry form. > > -- > Lynn Trapp > MS Access MVP > www.ltcomputerdesigns.com > Access Security: www.ltcomputerdesigns.com/Security.htm > Jeff Conrad's Access Junkie List: > http://home.bendbroadband.com/conradsystems/accessjunkie.html > > > > "Sprinks" <Spri***@discussions.microsoft.com> wrote in message > news:DDC4245E-D4F5-45BA-B2E0-5A25BC472B44@microsoft.com... > > Thanks, Lynn. > > > > How could I have this code execute on opening the database? I thought of > > putting it in another form, set as the default to open, but I'd think > > there'd > > be a cleaner way. > > > > Thank you. > > Sprinks > > > > "Lynn Trapp" wrote: > > > >> Read the Security FAQ for the UserInGroup function. You button for > >> opening > >> your forms could, then be something like this > >> > >> If UserInGroup("Admins") then > >> Open Administration menu form > >> Else > >> Open Timesheet form > >> End if > >> > >> -- > >> Lynn Trapp > >> MS Access MVP > >> www.ltcomputerdesigns.com > >> Access Security: www.ltcomputerdesigns.com/Security.htm > >> Jeff Conrad's Access Junkie List: > >> http://home.bendbroadband.com/conradsystems/accessjunkie.html > >> > >> > >> > >> "Sprinks" <Spri***@discussions.microsoft.com> wrote in message > >> news:92C02700-758C-47E6-8223-D512B7F2ECB4@microsoft.com... > >> >I have a Timesheet application for which I will be using Security for > >> >the > >> > first time. Most users will have read/edit permissions for a single > >> > form, > >> > by > >> > which they enter their time spent on various projects. I would like to > >> > load > >> > an Administration Menu form on startup for those in the Admins group, > >> > and > >> > the > >> > Timesheet form for the Users. > >> > > >> > Prior to securing the database, I've set the Adminstration Menu as the > >> > form > >> > to load on startup, and used a DLookup call in the Form_Open event to > >> > determine the value of a stored "FullAdminRights" field for the current > >> > user. > >> > If the user doesn't have the rights, the form closes and the Timesheet > >> > form > >> > opens. > >> > > >> > I'd rather let Security handle this, but if I remove User permissions > >> > for > >> > the Administration Menu form, will the Form_Open event procedure even > >> > run? > >> > If not, how can I load the Timesheet form? > >> > > >> > Thanks for all help. > >> > Sprinks > >> > >> > >> > > > 
Other interesting topics
Why are all access database I open asking for log on?
Security-Is there a better way? Help with an IF statement for the groups Need help with security Security permissions to convert the database Instead of Autoexec, can one startup with a module? Need help securing an application with detail records Locking a database Network security Logon to Access |
|||||||||||||||||||||||
