Form_SetPermissionLevels |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 03 May 2010 at 5:20am |
Form_SetPermissionLevels 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 DownLoad File >>: uploads/37/Form_SetPermissionLevels.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |