Password protection on a specific button?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Matt said:
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.
Click to expand...

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
 
Back
Top