Switchboard as Default

[Guest]

Hi this is probably pretty apparent, but I can find anything on it.

I would like the switchboard to be the first thing the user sees as opposed
to the switchboard in a pop-up with the menu showing behind it.

And I would like it to open in full page view, and fit on anyone's screen
regardless of settings. Is this possible?

 

[BruceM]

It's only apparent if you know what it's called. Click Tools > Startup. In
the Display Form/Page box, select your form. The menu to which you refer
(the first thing you see when you open Access) is called the Database
Window. There are some other boxes there in case you have a custom menu or
if you want to restrict user options. Post back if you have questions about
any of that stuff.
Try maximizing the switchboard in design view, then saving it. If that
doesn't work to make it fill the screen, open the form in design view, and
click View > Properties. Click the Events tab, click next to On Open, click
the three dots, click Code Builder, and click OK. The cursor should be
blinking between a line that starts Private Sub... and one that says End
Sub. Type DoCmd.Maximize. Don't worry about capitalization, and keep an
eye on the screen after you type Docmd. You will probably see a list of
choices. You can select the one you want or type it, as you prefer. Access
will adjust the upper and lower case letters.

 

[Guest]

Thanks Bruce. You really know your stuff.

It already says minimize. Can I just replace that word with Maximize and
have it work?

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub

 

[Guest]

You can create a macro named Autoexec and put in OpenForm and select the
switchboad as the form to open. In the second action row use Maximize.

 

[BruceM]

Thanks Bruce. You really know your stuff.

Thanks, but not really compared to some of the folks here from whom I have
learned so much. They have been generous with their time and advice, and I
try to return the favor by offering suggestions that fall within my
knowledge and experience.

It already says minimize. Can I just replace that word with Maximize and
have it work?

What already says minimize?

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub

In what form do these lines of code reside? What is that form's purpose?

The line containing the word "minimize" is preceded by an apostrophe, which
means the line is a comment and not executable code. Changing it to
"maximize" will do nothing. I don't see any need to minimize the database
window (the box with tabs for Tables, Queries, and so forth that you see
when you start Access) through code, and I don't see how the code you
provided would accomplish that in any case, but maybe I am missing
something.

If you click Tools > Startup you can clear the checkbox for "Display
Database Window". Also, select your switchboard from the Display Form/Page
box. Click the Advanced tab and make sure that box is still checked.
Unless you have custom menus and toolbars you should probably leave the
rest of the boxes checked. Open that form in design view, mazimize it, save
it, and close it. Close the database, then double-click to open it. It
should open to the form you chose as the Startup form. If that form is not
maximized, you can get to the database window by pressing F11, and switch to
design view from there (or you can use the toolbar icon if it's available).
Add the words DoCmd.Maximize to the code.

A switchboard is typically an unbound form (not associated with a table or
query) that contains buttons, etc. to open various objects (forms and
reports, mostly; an object is a table, query, etc. represented by a tab on
the database window). However, a form in which data are entered or
displayed, and which also has buttons to open other database objects, could
function as a sort of switchboard. If there is a filter (as the code
suggests) I suspect this is the case. If so, what exactly is a switchboard
page in this case? A tab on a tabbed form?