Disable button for some

[Guest]

I have created a start-up menu page with a button that I (as Admin) can use to exit the menu's and go to the tables. I want this button to NOT be available to some users

What do I need to do?

 

[Scott McDaniel]

You could use "mock" security and simple ask for a password on button click:

Sub YourButton_Click()

If Inputbox("Password: ") <> "Bob" then
Exit Sub
Else
<your code>
End If

Of course, this is easily circumvented. The better way is to show/hide the
button based on the current user's Group membership. Members of the Admins
group would see the button; others would not.

To do this, you'll have to implement User Level Security. This is not a
trivial task, and I would encourage you to tinker on a COPY of your
database. More info here:

http://www.google.com/url?sa=U&star...aq.asp&e=1102&mr=D/1!6295_,4!a_D:nr1m_spb2_mo


--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "

I have created a start-up menu page with a button that I (as Admin) can

use to exit the menu's and go to the tables. I want this button to NOT be
available to some users.