Form Security
in [Forms]
|
Prev: Open one form with different queries
Next: Can you add a Tab Control on the page of another tab control?
From: Michaelcip on 24 Mar 2010 18:00 Thanks in advance. I'm using 2003, I've set up security, I want to prevent a specific user from being able to modify specific fields in a form that opens up in datasheet view. I've attempted the following behind the form & it's not working: Private Sub Form_Load() If CurrentUser() = "blackman" Then Me.ID = vbReadOnly Me.GageNo = vbReadOnly Me.EmpNo = vbReadOnly Me.GageOwner = vbReadOnly Me.QA = vbReadOnly Me.QARecDate = vbReadOnly Me.QARetDate = vbReadOnly Me.EmpNoRecd = vbReadOnly Me.CalCategory = vbReadOnly End If End Sub Many thanks again, MC
From: John W. Vinson on 24 Mar 2010 20:04 On Wed, 24 Mar 2010 15:00:06 -0700, Michaelcip <Michaelcip(a)discussions.microsoft.com> wrote: >I'm using 2003, I've set up security, I want to prevent a specific user from >being able to modify specific fields in a form that opens up in datasheet >view. I've attempted the following behind the form & it's not working: If you're using Workgroup Security (which unfortunately limits you to the .mdb format in A2007 and later versions, since the security features are not available in the newer .accdb format), why not just set that user's premissions to read only on that table, query, or form? You're using security already - you don't need VBA code to tweak form properties to have it take effect! -- John W. Vinson [MVP]
From: Michaelcip on 26 Mar 2010 18:36
Thanks John. I had figured it out. Interesting though,...I didn't get a notification of your reply. Need to check into it. Have a great weekend. MC "John W. Vinson" wrote: > On Wed, 24 Mar 2010 15:00:06 -0700, Michaelcip > <Michaelcip(a)discussions.microsoft.com> wrote: > > >I'm using 2003, I've set up security, I want to prevent a specific user from > >being able to modify specific fields in a form that opens up in datasheet > >view. I've attempted the following behind the form & it's not working: > > If you're using Workgroup Security (which unfortunately limits you to the .mdb > format in A2007 and later versions, since the security features are not > available in the newer .accdb format), why not just set that user's > premissions to read only on that table, query, or form? You're using security > already - you don't need VBA code to tweak form properties to have it take > effect! > -- > > John W. Vinson [MVP] > . > |