Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 16 Jul 2018 at 6:14am

Topic: Form_SetPermissionLevels
Posted By: A.D. Tejpal
Subject: Form_SetPermissionLevels
Date 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

DownLoad File >>: - uploads/37/


Email: -

Print Page | Close Window