Securing Controls

[Owen]

Hello,

I'm trying to limit the use of various command buttons.
One button in particular opens a spreadsheet with
information not needed by all the users of the database.
Can this button be enabled and disabled with a password or
workgroup designation?

Any suggestions are welcome.

TIA

Owen

 

[Joan Wild]

The one thing I'd suggest is that you use .visible rather than .enabled

I find that users get annoyed (or think something is wrong) when they can
see something but can't make it work.

 

[TC]

Good point. I guess another approach would be to leave it enabled but make
it say, "Sorry, you do not have permission to do this. Please see your
system aministrator" or whatever.

TC

The one thing I'd suggest is that you use .visible rather than .enabled

I find that users get annoyed (or think something is wrong) when they can
see something but can't make it work.

--
Joan Wild
Microsoft Access MVP

me![cmdShowSpreadsheet].enabled = (err.number = 0)

 

[Joan Wild]

Good point. I guess another approach would be to leave it enabled but make
it say, "Sorry, you do not have permission to do this. Please see your
system aministrator" or whatever.

Perhaps, but I think that is annoying to users as well - makes them think
they aren't 'good enough' - maybe they aren't, but there's no need to shove
it in their face.