Different User, Different Button availability

  • Thread starter Thread starter UnknownJoe
  • Start date Start date
U

UnknownJoe

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.
 
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
 
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".
 
Back
Top