Hidden Buttons

[jbates83]

If I have a button thats has visible set to no, how can I have a second button make it visible?

 

[Mile-O]

on the second button's OnClick() event:

Me.cmdYourOtherButton.Visible = True

 

[jbates83]

Maybe I am an idiot, but it didn't work.

 

[Peter D]

Try putting this code

Me.cmdYourOtherButton.Visible = True

in the command button OnClick event procedure. Substitute "cmdYourOtherButton" with the name of your other command button.

If you're new at creating event procedures, please see Access help under "creating event procedures".

Hope this helps,

 

[jbates83]

If I click on a button, can I have it disappear? I am curious how, it says that I can't hide a control that has the focus, so how do I make it disappear

 

[Mile-O]

Set the focus to another control first.

 

[Mile-O]

Private Sub cmdThisButton_Click()
    Me.ctlOtherControl.SetFocus
    Me.cmdThisButton.Visible = False
End Sub

 

[jbates83]

I know that I am being annoying, but what is the procedure to close a form when a button is clicked and/or run a macro?

 

[Mile-O]

To close the active form:

DoCmd.Close acForm, Me.Name

To close an inactive form:

DoCmd.Close acForm, Forms!frmYourFormName

or

DoCmd.Close acForm, Forms("frmYourFormName")

To run a macro:

DoCmd.RunMacro "YourMacroName"

 

[jbates83]

I am trying to make a yes or no exit message box
if it is yes I want it to exit the form
if it is no I want it to go back to the form, but I cant seemk to get it right. Can someone help me?

 

[Mile-O]

If MsgBox("Do you wish to close this form?", vbQuestion + vbYesNo, "Title Here") = vbYes Then
    DoCmd.Close acForm, Me.Name
End If