Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Switchboard form is opening but immediately gets minimized

Discussion in 'Information Technology' started by tsison7, Jul 28, 2006.

  1. tsison7

    tsison7
    Expand Collapse
    Guest

    I have a command button to open up the switchboard after login. But when I
    login, the switchboard opens then minimizes automatically. How do I get it
    to open properly?
    --
    TIA
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Tia

    Open the form in design view.
    Right click on the grey section of the form (below to space where you put
    your buttons, box, lists, etc)
    On the dropdown box select Event
    Select On-Open
    Click the build options (three dots on the right)
    Select Code


    You will see this



    Private Sub Form_Open(Cancel As Integer)

    End Sub



    Insert one line of code (DoCmd.Maximize)

    So that your code looks like this



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



    Click Save and close your form.
    When you open it again it "should" stay maximixed.

    Hope this helps


    --
    Wayne
    Manchester, England.



    "tsison7" wrote:

    > I have a command button to open up the switchboard after login. But when I
    > login, the switchboard opens then minimizes automatically. How do I get it
    > to open properly?
    > --
    > TIA
     
  4. tsison7

    tsison7
    Expand Collapse
    Guest

    Thanks, it worked.
    --
    TIA


    "Wayne-I-M" wrote:

    > Hi Tia
    >
    > Open the form in design view.
    > Right click on the grey section of the form (below to space where you put
    > your buttons, box, lists, etc)
    > On the dropdown box select Event
    > Select On-Open
    > Click the build options (three dots on the right)
    > Select Code
    >
    >
    > You will see this
    >
    >
    >
    > Private Sub Form_Open(Cancel As Integer)
    >
    > End Sub
    >
    >
    >
    > Insert one line of code (DoCmd.Maximize)
    >
    > So that your code looks like this
    >
    >
    >
    > Private Sub Form_Open(Cancel As Integer)
    > DoCmd.Maximize
    > End Sub
    >
    >
    >
    > Click Save and close your form.
    > When you open it again it "should" stay maximixed.
    >
    > Hope this helps
    >
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "tsison7" wrote:
    >
    > > I have a command button to open up the switchboard after login. But when I
    > > login, the switchboard opens then minimizes automatically. How do I get it
    > > to open properly?
    > > --
    > > TIA
     
  5. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Glad to help.

    --
    Wayne
    Manchester, England.



    "tsison7" wrote:

    > Thanks, it worked.
    > --
    > TIA
    >
    >
    > "Wayne-I-M" wrote:
    >
    > > Hi Tia
    > >
    > > Open the form in design view.
    > > Right click on the grey section of the form (below to space where you put
    > > your buttons, box, lists, etc)
    > > On the dropdown box select Event
    > > Select On-Open
    > > Click the build options (three dots on the right)
    > > Select Code
    > >
    > >
    > > You will see this
    > >
    > >
    > >
    > > Private Sub Form_Open(Cancel As Integer)
    > >
    > > End Sub
    > >
    > >
    > >
    > > Insert one line of code (DoCmd.Maximize)
    > >
    > > So that your code looks like this
    > >
    > >
    > >
    > > Private Sub Form_Open(Cancel As Integer)
    > > DoCmd.Maximize
    > > End Sub
    > >
    > >
    > >
    > > Click Save and close your form.
    > > When you open it again it "should" stay maximixed.
    > >
    > > Hope this helps
    > >
    > >
    > > --
    > > Wayne
    > > Manchester, England.
    > >
    > >
    > >
    > > "tsison7" wrote:
    > >
    > > > I have a command button to open up the switchboard after login. But when I
    > > > login, the switchboard opens then minimizes automatically. How do I get it
    > > > to open properly?
    > > > --
    > > > TIA
     

Share This Page