Load Switchboard Maximum

[CKreig]

I have a form called Switchboard. I have it to load when the application is
opened, however I cannot find where On Load. When I am in the properties
this is what I get:
Force New Page
New Row or Col
Keep Together
Visible
Display When
Can grow
Can Shrink
Height
Back Color
Special Effect
Can you please help me. Thank you in advance.

 

[Jeff Boyce]

I'm not sure I'm following...

Are you saying that you want Access to load your frmSwitchboard when it
opens that database? If so, you tell Access to use the form during startup
(you don't tell the form). Which version of Access are you using? (where
you tell Access depends on version)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Petty]

Depending on the version of Access you are usng, go to Tools/Startup. In this
dialog box, you can define what form, etc. that the app uses as a startup.

 

[Olduke]

Create a macro and name it Autoexec. Access will run to the Autoexec macro
first every time it opens the database.
On the top line select Open Form. At the bottom you can select the form to
be opened. Enter Switchboard.
I would also suggest you include the command Maximize in Autoexec as well.
It will increase the Access database to full screen.

 

[CKreig]

I have access 2003. I went to there and the Switchboard is to come up,
however it does not come up in maximize it is very small. That is what I
would like to change.

 

[CKreig]

I have version 2003 and I do not see where on startup I can have it open on
maximum. I do have it opening to the switchboard form.

 

[John Petty]

CKrieg,

In Access 2003, you have a tools/Startup. In this dialog, In the Display
Form Textbox, type in the name of your Switchboard form.

Next, use the "On-Open" event to add an event Procedure. when prompted,
choose the "Code editor" and this will invoke the VBE (Visual Basic Editor).
Under the "sub" type in DoCmd.Maximize

It should look something like this

Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize
End Sub

This should force the Switchboard form to open in Maximized format

 

[CKreig]

John-
I am sorry I do not mean to sound so stupid here as that is how I am
feeling. Is the On Open in the same window or where do I find that?

 

[John Petty]

Open your form in Design Mode. RMB (Right Mouse Button) anywhere in the form
and select properties (this is at the bottom of the list). Since you are
using Access 2003, you should have a combo box at the top of the properties
dialog box. Open this and find the name of the form (i.e. fmSwitchboard).

Once you have the properties for the form, click on the "Events" tab. scroll
down until you see the "On Open" Event. If you click in the textbox, you will
get a couple of options and an ellipse (...) button next to the textbox.
Click on this and choose code builder.

Then type the following into the subroutine
DoCmd.Maximize

This should do the trick.

Best of luck.

 

[CKreig]

John-
When I click on properties all I get is a general tab. Is there anyway to
email you this so you can see what I am talking about?