Securing Controls

  • Thread starter Thread starter Owen
  • Start date Start date
O

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
 
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.
 
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


Joan Wild said:
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

TC said:
me![cmdShowSpreadsheet].enabled = (err.number = 0)
 
TC said:
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.
 
Back
Top