Access 2016 Minimize/Restore Switchboard

[randyduly]

I have a Switchboard with two buttons on it. If I click on the first button the switchboard minimizes and when I am done with the form. I click on the “Close Form” button. The form closes and the Switchboard pops back open. Now my second button when I click on it, the form opens up, but the switchboard stays right there on the screen with the form behind it.When I click on its “Close Form” button, form closes.

I am still very much a novice, since I have not really done anything in Access since Access 2007. Where would the code or properties be, so I can fix this second button?

Thanks in advance.

Randy

[jeanniejones]

ther a way you can mim inize and maximize a form with a buton it does require some vba code.

creste another button

then on the onclick event put this

If Advanced.Caption = “>>” Then
Advanced.Caption = “<<”
Else
Advanced.Caption = “>>”
End If
ResizeListBox

End Sub

Private Sub ResizeListBox()

If Advanced.Caption = “<<” Then
DoCmd.MoveSize , , WidthLarge
CustomerSearchList.ColumnWidths = “0"”;0"“;0.5"”;0.7"“;1.2"”;1.4"“;0.2"”"
CustomerSearchList.Width = ListLarge
LastAccessedSort.Visible = True
TimesAccessedSort.Visible = True
Else
DoCmd.MoveSize , , WidthSmall
CustomerSearchList.ColumnWidths = “0"”;0"“;0.5"”;0.7"“;1.2"”;0"“;0"”"
CustomerSearchList.Width = ListSmall
LastAccessedSort.Visible = False
TimesAccessedSort.Visible = False
End If

End Sub

[kevinhughes2]

With the form open in design view, right click the button → properties → click events tab, OnClick , ellipsis next to event procedure opens the code window

[randyduly]

Thank you, I was blind as a bat, It was right there in front of my eyes when I looked at the first button again. It was just one of those days.

BTW, does anybody know how to add a file to this forum, in case I want someone to look at one of my Access database? I tried attaching a .zip and .rar and .accdb. This forum would not accept them.

Again thanks for the help with my Access question above.

[kevinhughes2]

If it’s VBA code that you’re having trouble with, just copy it from the code window, click </> and paste it in the pop-up as vb.net

Access DBs always contain miles of VBA … and most of us are leery of downloading them because … security. Pretty sure you can post OneDrive or similar links but you’ll have to put it somewhere in the cloud first. It goes without saying that confidential data should be scrubbed first.

When you have questions, just try to be as specific as possible without writing War and Peace … e.g.

My query should pick up records where the value of … field matches … control in my form but it gives … records instead (and screenshot the relevant part of the query)

If you ask a good question, we probably won’t need to see the actual DB to help.

[randyduly]

Thank you for the info. Even though I been in IT for quite a while, I am still a newbie in SpiceWork forums.But it is one of the best forums around. Have a good day all.

Randy