another user access Question

minder

New member
Local time
Yesterday, 16:30
Joined
Jun 10, 2004
Messages
8
ok i have now sorted it thanks anyway for looking




ok this is what i want to do

the following code enables or disables a command button on page open depending on the users access level

Private Sub Form_Open(Cancel As Integer)

Select Case User.ViewID
Case 1, 2
Me.Command117.Enabled = True
Case Else
Me.Command117.Enabled = False
End Select

Exit_Form_Open:
Exit Sub

Err_Form_Open:
MsgBox Err.Description
Me.Visible = True
Resume Exit_Form_Open
End Sub



what i would like to achive is to have 2 command buttons contolled by the code but i cant seen to figure out how to do it

yhanks for any help ;)

rob
 
Last edited:

Users who are viewing this thread

Back
Top Bottom