Password protection on a specific button?

[Matt]

From what I understand there is a way to put password protection on a
specific button on a form and not have to put it on the entire database. If
this correct, does anyone have a step-by step way to handle this, or a link
to where i can go to find this. I've been pulling my hair out trying to
figure it out and can't seem to do it.

Any help? I would appreciate it.

Thanks.

 

[Keith Wilby]

From what I understand there is a way to put password protection on a
specific button on a form and not have to put it on the entire database.
If
this correct, does anyone have a step-by step way to handle this, or a
link
to where i can go to find this. I've been pulling my hair out trying to
figure it out and can't seem to do it.

Any help? I would appreciate it.

Thanks.

No, you can't do that, but what you can do is use the CurrentUser function
to determine who's logged on and set the button's "enabled" property
accordingly in the form's open event:

If CurrentUser = "Joe Bloggs" Then
Me.cmdMyCommandButton.Enabled = True
Else
Me.cmdMyCommandButton.Enabled = False
End If

HTH - Keith.
www.keithwilby.com

 

[Joan Wild]

You can password protect a single form or report, assuming your button opens
a form/report.
See these knowledge base articles:
http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371