Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Form_SetPermissionLevels
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Form_SetPermissionLevels
    Posted: 03 May 2010 at 5:20am

Explanatory Notes

    This sample db demonstrates setting of permission levels (e.g AllowAdditions, AllowEdits etc) for various forms as applicable to different user groups.

    On selecting (or entering - if new) the name of desired form in bound text box on form F_SetPermissions_Main, a matrix of virtual records is presented in the subform, displaying settable properties (e.g AllowAdditions, AllowEdits etc) against each group ID. Each GrpID in table T_Grps is represented by one virtual record in this matrix.

    As and when any of the properties is set by clicking the check box in pertinent column, the erstwhile virtual record gets converted into an actual record in table T_Permissions. This way, the table is not burdened with redundant records (e.g. groups for which no permission has been set). At the same time, full matrix (of virtual plus actual records) is always available for convenient setting or editing of permissions for the given form, group-wise.

    During the process of setting permissions, GrpID column of each record gets conditionally highlighted, depending upon the numbers granted as against overall total.

    Demonstration of using the permissions set as above, is provided via form F_LoadForms. On selecting an employee from the combo box, followed by entering of correct password and clicking the log-in button, the user can select the form to be loaded - via the adjacent combo box. The selected form, with prescribed permissions duly enforced, gets loaded as a subform. For ready appreciation the permission status gets displayed at top. Text boxes representing various permissions get highlighted in appropriate color, depending upon YES / NO status.

Version:  Access 2000 File Format

Reference:  DAO 3.6


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.