Probably a daft question ...

[m.cringle]

I know this will pretty simple but ...

When I open my database, the switchboard doesn't open maximised (as do
none of the other forms until I manually maximise) - surely there is a
way to do this automatically?

Thanks

 

[Van T. Dinh]

In the Procedure for the Activate Event of the Form, use the VBA statement:

DoCmd.Maximize

 

[m.cringle]

In the Procedure for the Activate Event of the Form, use the VBA statement:

DoCmd.Maximize

Was just trying this when got your response - would be perfect but I
have a splash-screen that appears first. Unfortunately it shows this in
full screen now and after the switchboard.

Any way to make just the switchboard maximise (after the splash-screen)?

 

[Douglas J. Steele]

Was just trying this when got your response - would be perfect but I
have a splash-screen that appears first. Unfortunately it shows this in
full screen now and after the switchboard.

Any way to make just the switchboard maximise (after the splash-screen)?

Where did you put the DoCmd.Maximize? Van's suggestion is to put it in the
Activate event of the switchboard form. That means it should only fire when
the switchboard is activated, not before.

 

[m.cringle]

Where did you put the DoCmd.Maximize? Van's suggestion is to put it in the
Activate event of the switchboard form. That means it should only fire when
the switchboard is activated, not before.

I put in the following code:

Private Sub Form_Activate() (On the Switchboard)

DoCmd.Maximize

End Sub

For some reason it max's the switchboard first, then displays the
screen-spash (in max page form which don't want) and then reverts back
to max'd switchboard. The command seems to max everything for some
reason

 

[Douglas J. Steele]

I put in the following code:

Private Sub Form_Activate() (On the Switchboard)

DoCmd.Maximize

End Sub

Hmm. I would have expected that to work.

Do you want the splash? If not, create a tiny bmp file (1 pixel x 1 pixel is
fine), name it the same as the MDB file (i.e.: if your MDB is MyApp.MDB,
name the bmp file MyApp.BMP) and put it in the same directory as the MDB
file.

For some reason it max's the switchboard first, then displays the
screen-spash (in max page form which don't want) and then reverts back
to max'd switchboard. The command seems to max everything for some
reason

The command will max everything: that's the way MDI (multi-document
interfaces) are intended to work.

 

[Van T. Dinh]

You may like to try:

http://www.mvps.org/access/api/api0022.htm

 

[m.cringle]

You may like to try:

http://www.mvps.org/access/api/api0022.htm

This seems a little hardcore for me - is there no easier way? I don't
really understand these API's

 

[Van T. Dinh]

I expect Terry Kreft (the author of the article) would write simpler code if
it is possible.

In fact, very similar code is also posted by Microsoft in Microft' Help and
Support Web site:

http://support.microsoft.com/kb/210299