Switchboard

Is it posible to get Access to open with the switchboard opening in
maximised view ?

re: Switchboard

On 24 Jan 2006 07:24:54 -0800, "Decreenisi" <cynan2torcs@hotmail.com> wrote:
[color=blue]
>Is it posible to get Access to open with the switchboard opening in
>maximised view ?[/color]

In the Open event of the form put -

DoCmd.Maximise

Wayne Gillespie
Gosford NSW Australia

re: Switchboard

In the Open event of the form, call a macro that has the Maximize action.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Decreenisi" <cynan2torcs@hotmail.com> wrote in message
news:1138116294.295149.268970@g14g2000cwa.googlegr oups.com...[color=blue]
> Is it posible to get Access to open with the switchboard opening in
> maximised view ?[/color]

re: Switchboard

Thanks Wayne,

But how do I get to the Open Event ?

re: Switchboard

On 24 Jan 2006 07:44:35 -0800, Decreenisi wrote:
[color=blue]
> Thanks Wayne,
>
> But how do I get to the Open Event ?[/color]

Open the switchboard in Design View.
Display the Switchboard's property sheet.
Click on the Data tab.
On the line that says "On Open", write:
[Event Procedure]
Note: If you are using the built-in Switchboard (created by the
Switchboard manager) the above [Event Procedure] has already been
written.

Then click on the little button with 3 dots that appears on that line.
When the code window opens the cursor will be flashing between 2 (or
more) already existing lines of code.
directly under the
Private Sub Form_Open(Cancel As Integer)
line write:

DoCmd.Maximize

Save the changes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

re: Switchboard

With the form open in Design View, on the toolbar click View |
Properties if the Properties box isn't already open. Then click the
Events tab of the Properties box, find the line that says 'Open', and
click inside the textbox. To the right of the textbox will be an
ellipses (...). Click the ellipses and choose Code Builder. Now you
will be in the Form_Open event. Paste Wayne's code before the line that
says 'End Sub'. Close the window, then open your form. The code in the
Form_Open event should fire.

re: Switchboard

On 24 Jan 2006 07:44:35 -0800, "Decreenisi" <cynan2torcs@hotmail.com> wrote:
[color=blue]
>Thanks Wayne,
>
>But how do I get to the Open Event ?[/color]

Open the form in design view and open the properties box.
On the Event tab of the properties box click on OnOpen.
Type [EventProcedure] and click on the button with the 3 dots at the right.

The code module will open with the lines

Sub Form_Open(Cancel As Integer)

End Sub

Put you code between these 2 lines.


Wayne Gillespie
Gosford NSW Australia