user accessibility level

[Shannon]

Hi,

How can I limit users' accessibility base on users' levels?

Is there a way to allow user to see information of a
record on a form but only allow them to change certain
part of a form and block the rest from editing but read
only?

thanks,

 

[Rick B]

Just change the "locked" or "enabled" property of the fields you don't wish
them to change. Look at those two fields and use "help" to get more
information. Basically, locking it prevents changes, but still let's them
copy from the field and filter on it. Un-enabling it makes it where they
can't even highlight the field.

Rick B


Hi,

How can I limit users' accessibility base on users' levels?

Is there a way to allow user to see information of a
record on a form but only allow them to change certain
part of a form and block the rest from editing but read
only?

thanks,

 

[Rick B]

You know, after reading your post again, I think you want to change it based
on who is using the form. The only way I know to do so is to write code
that sets the enabled or locked property based on the userid or group of the
person signed on. Just build some IF statements in your code.

Rick B

Just change the "locked" or "enabled" property of the fields you don't wish
them to change. Look at those two fields and use "help" to get more
information. Basically, locking it prevents changes, but still let's them
copy from the field and filter on it. Un-enabling it makes it where they
can't even highlight the field.

Rick B


Hi,

How can I limit users' accessibility base on users' levels?

Is there a way to allow user to see information of a
record on a form but only allow them to change certain
part of a form and block the rest from editing but read
only?

thanks,

 

[Shannon]

You're right Rick, that's exactly how I want.
Would you show me what the code is or give me an example
of what it is?
I want the code to be able to tell the users' levels when
they log in and provide them information of what they can
see or edit changes.

Thanks,

 

[Rick B]

There is a public function that you will have to build to find out if they
are members of a particular group. I don't use it, but I think Joan Wild
has posted links to it in the newsgroups recently. You might do a search.
If you simply base it on the userid, your statement would look something
like...

Private Sub Form_Open(Cancel As Integer)

If CurrentUser() = "SMITHJOHN" then
Me!SomeFieldName.Enabled = True
Else Me!SomeFieldName.Enabled = False
End If

End Sub


Rick B



You're right Rick, that's exactly how I want.
Would you show me what the code is or give me an example
of what it is?
I want the code to be able to tell the users' levels when
they log in and provide them information of what they can
see or edit changes.

Thanks,