If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Different User, Different Button availability
Is it possible within a DB to only allow certain buttons to be visble or
active for certain users? I'm assuming this would all have to be Username and Password related. Thanks. |
#2
|
|||
|
|||
Different User, Different Button availability
Yes.
One way would be to based it on security implemented via Access security. Another would be useful if you're working on a netword with network logons. Which is more suitable in your situation? Regards Jeff Boyce Microsoft Access MVP "UnknownJoe" wrote in message ... Is it possible within a DB to only allow certain buttons to be visble or active for certain users? I'm assuming this would all have to be Username and Password related. Thanks. |
#3
|
|||
|
|||
Different User, Different Button availability
UnknownJoe,
Yes... You assume correctly but I would add... UserName, Password, ShowButtons (Yes/No). The way you could update a table and not have to *hard code* UserName and/or Password. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "UnknownJoe" wrote in message ... Is it possible within a DB to only allow certain buttons to be visble or active for certain users? I'm assuming this would all have to be Username and Password related. Thanks. |
#4
|
|||
|
|||
Different User, Different Button availability
Yes, you can do that.
You can identify the user using function fosUsername (google it). Then you can set the visible property to true or false depending on the user. This can be done in the form load event. Normally this would be table driven, you define all your users in a table and for each have additional column indicating their capabilities. For instance, I have several applications that allow certain users to make updates and certain users to be read-only. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "UnknownJoe" wrote: Is it possible within a DB to only allow certain buttons to be visble or active for certain users? I'm assuming this would all have to be Username and Password related. Thanks. |
Thread Tools | |
Display Modes | |
|
|