TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • July 23, 2006 at 9:38 pm #2259441

    Access Switchboard

    Locked

    by ljackson.desoto · about 16 years, 10 months ago

    Hello-
    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!

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • July 24, 2006 at 2:22 pm #3207653

      Reply To: Access Switchboard

      by maevinn · about 16 years, 10 months ago

      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:

      docmd.Maximize

      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.

    • September 15, 2006 at 11:16 pm #3227169

      Reply To: Access Switchboard

      by dpahari23 · about 16 years, 8 months ago

      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.

  • Author
    Replies
Viewing 1 reply thread