Results 1 to 2 of 2
  1. #1
    FrogIce is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    1

    Using Filters to Restrict/Hide Entries in a Database

    Hey guys,
    I'm relatively new to programming in Access, and I'm having problems filtering my database so that only certain users can see entries. I'm using the SharePoint Projects Web Database, and want to restrict users from seeing files that are deemed confidential. To solve this, I tried creating a hidden yes/no column and marking the specific entry as being restricted. Then I attempted to write an on load macro that filtered the database for everyone but the specific users, using the CurrentWebUser command, to only see the not confidential entries. However, I can't seem to get it to work. Any help would be greatly appreciated.

    If
    CurrentWebUser(2) <> "NAM\test"
    SetFilter"="WhereCondition">[Forms]![OpenProjects][Restricted]=No

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    What is NAM\test - a declared variable or a fieldname?
    Is SetFilter a declared variable?

    Post the complete code procedure.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-22-2010, 01:29 PM
  2. Hide database window in Access 2010
    By Kevin Johnston in forum Access
    Replies: 5
    Last Post: 09-23-2010, 09:44 AM
  3. Restrict Table values
    By Suzied in forum Access
    Replies: 1
    Last Post: 03-27-2010, 11:14 AM
  4. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 PM
  5. Hide the Database window
    By wasim_sono in forum Access
    Replies: 5
    Last Post: 02-02-2006, 06:41 AM

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