General discussion

  • Creator
  • #2259441

    Access Switchboard


    by ljackson.desoto ·

    I am working with a database that has a switchboard. When you open, the switchboar and the main database open up in windows and then you have to maximize the switchboard.

    I believe there is a way to make the switchboard maximize upon opening the database, but I don’t know how to make this happen. Help!

All Comments

  • Author
    • #3207653

      Reply To: Access Switchboard

      by maevinn ·

      In reply to Access Switchboard

      Open the form in design view, and open Properties for the form. Find On Open (either Event or All tab) and click to enter an Event Procedure.

      In the Private Sub that is created, enter this:


      Save, and you’re good to go. You can also create this as a Public Sub and have it apply to all forms as they open, but it can be a pill if you have anything where a user needs to have 2 things open at once (ie, a form and a report, 2 different forms, etc). Bulding it as a macro and applying it to specific forms as needed works as well, but I prefer using VBA code to macros.

    • #3227169

      Reply To: Access Switchboard

      by dpahari23 ·

      In reply to Access Switchboard

      If you hide all other forms other than switch board, then you may not require to maximize the size of the switch boards.
      To do this, if you go to Tools then to startup and select only the switch (form name) as a start up form.

      Hope this helps.

Viewing 1 reply thread