User Profile

Collapse

Profile Sidebar

Collapse
Ryan Penter
Ryan Penter
Last Activity: Aug 1 '11, 08:07 AM
Joined: Mar 7 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ryan Penter
    replied to Change field 'Locked' property in VBA
    in Access
    Thanks for replying. So what would I write in the VBA code... something like

    Code:
    If username = "Bob" Then
Set rst_tbl = dbsDB.Openrecordset"tblMainData")
    With rst_tbl
        !Field.Locked = TRUE
    End with
Else End If
    See more | Go to post
    Last edited by NeoPa; Mar 7 '11, 10:08 PM. Reason: Please use the CODE tags

      Leave a comment:

    • Ryan Penter
      started a topic Change field 'Locked' property in VBA
      in Access

      Change field 'Locked' property in VBA

      Hi,
      I have a database which is used by multiple users. They access it via a login screen and then via a main form. The main form displays a table. When certain users log in, I want them to be able to edit a specific field, whereas when other users log in I want them to have read only access to the field.
      What do I need to write in the VBA when the user logs in to amend the 'Locked' property of the field? (assuming this is the right/best...
      See more | Go to post
      No activity results to display
      Show More
      Working...