Hello:

What is the best way to prevent a certain user name/group from using one of the buttons I created for admin use? Can I put a password on a button? The button performs a script. I want the general users to be able to use all the other buttons on the layout except one. Thanks

Mike

Mike:

You can add a test for Status(CurrentUserName) into the beginning of the script which throws you out of the script upon failure, shows an error message, whatever.

-Stanley

Mike,

You can use a portal to hide the button (as well as other objects on the layout). When the relationship a portal is based on is invalid, the portal will disapear along with any objects contained within it.

Build a self relationship which is valid only when the administrator, or someone from the administrator group is logged into the database. Place the button inside the portal. When a user logs in who does not have administrator privleges the portal will disappear along with the button.

There should be some examples from the professionals on this board floating around. If not let me know and I will put one up.

Tom

A less elegant (but handy) solution is to use the Status(CurrentModifierKeys) function in the first line of your script. Only users who click the button while pressing the correct key combination of shift/ctrl/alt (whatever you specify) will be able to run the script.

cheers,

Wendy