How to get _only_ the switchboard open as maximized, pls?

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

I have this as the opening code:
****************************************
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Maximize

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

Form_Open_Exit:
Exit Sub

Form_Open_Err:
MsgBox Err.Description
Resume Form_Open_Exit

End Sub
****************************************

Initially, the DoCmd line above said "DoCmd.Minimize" which did minimize the
db window but left the switchboard as a normal window. So I just changed
that to "Maximize". Now, yes, the Switchboard opens up completely but so
does the db window. How can we have one without the other, i.e., minimize
db window yet maximize switchboard?

Thank you.
 
G

Guest

Why do you need to minimize the database form when you have maximized the
switchboard as it fills the screen?

Try this --
On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Database", True
DoCmd.Minimize

DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Maximize
 
S

StargateFanFromWork

Thanks for helping; it seemed like this might work. I got an error message.

I come from Filemaker so it seemed like the behaviour was similar, but it's
not. Sorry about that. It seems that Access again shows me how differently
it behaves. I'm still getting used to those differences. I was trying to
mimic behaviour because that's what I'm used to. But I can live with
everything maximized like this.

I'm still in the very beginning stages of Access. It's very unlike FMP
though there are some similarities. They each have their strengths and
weaknesses. What I love about FMP is how intuitively easy it is to use and
its extreme versatility. What I am getting to love about Access are those
queries! <g>

Thanks. :blush:D


KARL DEWEY said:
Why do you need to minimize the database form when you have maximized the
switchboard as it fills the screen?

Try this --
On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Database", True
DoCmd.Minimize

DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Maximize


StargateFanFromWork said:
I have this as the opening code:
****************************************
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Maximize

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

Form_Open_Exit:
Exit Sub

Form_Open_Err:
MsgBox Err.Description
Resume Form_Open_Exit

End Sub
****************************************

Initially, the DoCmd line above said "DoCmd.Minimize" which did minimize the
db window but left the switchboard as a normal window. So I just changed
that to "Maximize". Now, yes, the Switchboard opens up completely but so
does the db window. How can we have one without the other, i.e., minimize
db window yet maximize switchboard?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top