Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179

    Error in Code

    Thanks but I get error at:

    Me.AFRsParts.Form.AllowEdits = False

  2. #17
    Join Date
    Apr 2017
    Posts
    1,776
    As about displaying only certain records by some criterion, then I have a devices database, where in devices table is calculated field (UL - UserLevel) which contains structured integer value for every device.
    E.g. when the device is used in one country, then this field has values from 0 to 10 (values 0 and 1 used in one factory - real people and group users like workstation or department respectively, 2 and 3 in another factory, etc.)
    When the device is used in second country, values are from 10 to 19, etc.

    Then form 90 and up are values for broken devises, devices sent to repair, free devices, etc. And value 99 is reserved for archived/out of use devices. Btw, all those statuses are defined as users.

    The Main form is unbound, and the form for device management is a subform in it. A combo box in main form allows to set various filters on subform, like:
    All active devices - UL<99
    All devices from certain country - like UL between 0 And 9
    All devices from certain factory - like UL between 0 and 1
    All active devices not used currently - UL between 90 and 98
    All archived devices - UL = 99

    And of course you can use this to determine are records editable or not. My main concern is to avoid accidental changes, so all info is always disabled, and only enabled controls are for selecting device, and for enabling editing. And Current event disables any not new record.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 06-19-2017, 11:06 AM
  2. Locking Fields on a Table on a Form
    By Loup in forum Access
    Replies: 18
    Last Post: 05-02-2017, 06:47 AM
  3. NOT printing certain fields in a report
    By papabill in forum Queries
    Replies: 2
    Last Post: 02-22-2015, 06:42 PM
  4. Replies: 3
    Last Post: 12-29-2014, 01:04 PM
  5. Locking fields in Access form
    By sk88 in forum Access
    Replies: 10
    Last Post: 06-04-2012, 01:40 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