Results 1 to 2 of 2
  1. #1
    dcmphi is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Posts
    2

    How to disable a combo box value with security level


    i have a database with login system with user security level. There are 3 type User super admin, Admin and user. SuperAdmin and admin has access permision to add new user. My question is how to disable access level (superadmin) for admin when admin add an user. I want this function because only super admin can create an superadmin user not admin. Ple anyone help me. Thanks...

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not enough info to provide a definitive answer, but assuming your combobox is a value list and the current user access level is held in a global variable then in the combobox enter event or perhaps the form current event put

    Code:
    if gbluseraccesslevel="superadmin" then
        cboaccesslevel.rowsource="superadmin,admin,user"
    else
        cboaccesslevel.rowsource="admin,user"
    end if

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Get User Automatically and Security Level example
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 12-10-2015, 12:11 PM
  2. Form Level Security
    By brispark in forum Sample Databases
    Replies: 2
    Last Post: 08-16-2014, 08:35 AM
  3. Form Level Security
    By Gina Maylone in forum Security
    Replies: 4
    Last Post: 12-18-2013, 01:21 PM
  4. User Level Security
    By A kinason in forum Sample Databases
    Replies: 6
    Last Post: 11-02-2013, 02:00 AM
  5. help with security level
    By nojtuag in forum Access
    Replies: 3
    Last Post: 10-19-2011, 01:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums