 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / July 2004user accessibility level
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, 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, 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, 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, >-----Original Message----- >You know, after reading your post again, I think you want to change it based [quoted text clipped - 24 lines] > >. 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, >-----Original Message----- >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 > >"Rick B" <anonymous@discussions.microsoft.com> wrote in message >news:uoaVWJnaEHA.2260@TK2MSFTNGP10.phx.gbl... >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 > >"Shannon" <anonymous@discussions.microsoft.com> wrote in message >news:2d9a501c46a6f$b54998f0$a501280a@phx.gbl... >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 [quoted text clipped - 4 lines] > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.