Show all Buttons

[Pestomania]

I have the code to make a button visible or not based on their user group. But is there a way to say if user = "poweruser" show all buttons?

 

[Micron]

Certainly. You'd loop through all the controls on a form and for those that are command buttons, set their visible property. Assumption made on how you determine if the condition is true (untested):

Dim ctl As Control

For Each ctl in Me.Controls
  If ctl.ControlType = acCommandButton And User = "power user" Then
  ctl.Visible = True
End If

 

[Pestomania]

Certainly. You'd loop through all the controls on a form and for those that are command buttons, set their visible property. Assumption made on how you determine if the condition is true (untested):

Dim ctl As Control

For Each ctl in Me.Controls
  If ctl.ControlType = acCommandButton And User = "power user" Then
  ctl.Visible = True
End If

This is awesome!! I'll try it out in the morning, but I'm sure it works great!!