Results 1 to 5 of 5
  1. #1
    swenger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    151

    Controlling modification of records

    I have a database where I have a login form and a variable stores the user which is logged in. Certain Forms I set the Allow Additions, Deletions and Edit to NO. I created code which on Open would check the user variable and if the user is allowed to modify I set the Allow Edits to True. My issue is with the restricted users, I want them to be able to browse the data. I have Combo Boxes to enter info to pull up records but they are unable to type or click on these drop downs which I suspect have to do with the NO I set on the form.

    How can I keep them from modifying the records but still allow them to use the Combo box.

    Thanks


    Sam

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    As long as the combo box doesnt alter data then it shouldnt matter.
    Set the form to snapshot, then records cant be altered, like edit=no.

  3. #3
    swenger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    151
    I realized that the the Records are on a subform and the combo is on the main form so I changed the main form to allow edits and kept the sub-form as no edits and all is well now.

    For my knowledge what is snapshot. I have always used Dynaset

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    snapshot is a readonly dataset
    dynaset is editable

  5. #5
    swenger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    151
    Thanks. Good to know

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

Similar Threads

  1. Northwind Template Modification
    By Raleyoz in forum Access
    Replies: 11
    Last Post: 06-29-2015, 05:11 PM
  2. Controlling the Number of Records in a Subform
    By dgutsche in forum Programming
    Replies: 2
    Last Post: 08-19-2014, 10:13 AM
  3. Query modification
    By endri81 in forum Queries
    Replies: 28
    Last Post: 02-29-2012, 09:50 AM
  4. Access total UI modification
    By Overdive in forum Access
    Replies: 5
    Last Post: 10-25-2009, 05:53 AM
  5. DoCmd.OpenForm Modification
    By alsoto in forum Forms
    Replies: 6
    Last Post: 05-01-2009, 07:28 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