Database Window Control

[Rohn Everson]

I copied a switchboard from a Microsoft Templete (Contributors), made my own
modifications and it works great accept when it launches. The Database
Window in minimized instead of hidden now? Design is: SQL nine table
backend with SQL server permissions and an Access frontend.

I don't want the users to get to the actual database controls. They just
need to use the three forms/subforms and seven reports off of the
switchboard! I looked at the help files but did not find anything helpful.

Thanks for any suggestion you might have,
Rohn

 

[aaron.kempf]

I believe that you can right-click in the object pane- and choose
startup options.

Or just choose TOOLS, Startup I think that it's just called that...

and then just uncheck the box that says 'display database window'

-Aaron

PS - if you're using SQL Server; are you using ADP? Should you be?

 

[Rohn Everson]

Thanks Aaron,

I do have the 'display database window' unchecked. Which this worked fine
when I was just displaying one form. I now have three different forms and
now using a switchboard and the database window is now only minimized, not
hidden even though the box is unchecked?

I am not sure what ADP is, but the backend is on our SQL server!

thanks again, Rohn

I believe that you can right-click in the object pane- and choose
startup options.

Or just choose TOOLS, Startup I think that it's just called that...

and then just uncheck the box that says 'display database window'

-Aaron

PS - if you're using SQL Server; are you using ADP? Should you be?

 

[aaron.kempf]

Under the File Menu, Select New, and then 'Project (existing data)'.

Type in your server name.
Your db name.

Right click import all your forms. Presto-chango-- you've got all
your queries where they belong (ON THE DATABASE SERVER).

PS - i'd reccomend using Access 2007 with SQL 2005 or Access 2000-2003
works _GREAT_ with SQL 7.0, 6.5 and 2000.

 

[Rohn Everson]

Thanks again Aaron,

ADP looks like it will make the database run even better. On the other
issue, any ideas how to change the database window to hidden now that I am
using this switchboard. In looking at the code (which I know very little
about) its Event Procedure says: DoCmd.Minimize can I tell it to DoCmd.Hide
or DoCmd.NoShow or something?

Code look like this:

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.Minimize

' 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


Under the File Menu, Select New, and then 'Project (existing data)'.

Type in your server name.
Your db name.

Right click import all your forms. Presto-chango-- you've got all
your queries where they belong (ON THE DATABASE SERVER).

PS - i'd reccomend using Access 2007 with SQL 2005 or Access 2000-2003
works _GREAT_ with SQL 7.0, 6.5 and 2000.

 

[aaron.kempf]

I still don't get the problem.

You say that the checkbox is set to unchecked-- the one that says
'display db window'.

And the db window is still showing up? Sounds to me like you are
currently _UNHIDING_ it programmatically.
So I'd undo the unhide instead of hiding again

-Aaron

Thanks again Aaron,

ADP looks like it will make the database run even better.  On the other
issue, any ideas how to change the database window to hidden now that I am
using this switchboard.  In looking at the code (which I know very little
about) its Event Procedure says: DoCmd.Minimize can I tell it to DoCmd.Hide
or DoCmd.NoShow or something?

Code look like this:

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.Minimize

    ' 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


Under the File Menu, Select New, and then 'Project (existing data)'.

Type in your server name.
Your db name.

Right click import all your forms.  Presto-chango-- you've got all
your queries where they belong (ON THE DATABASE SERVER).

PS - i'd reccomend using Access 2007 with SQL 2005 or Access 2000-2003
works _GREAT_ with SQL 7.0, 6.5 and 2000.

Thanks Aaron,

I do have the 'display database window' unchecked. Which this worked fine
when I was just displaying one form. I now have three different forms and
now using a switchboard and the database window is now only minimized, not
hidden even though the box is unchecked?

I am not sure what ADP is, but the backend is on our SQL server!

thanks again, Rohn

<[email protected]> wrote in message

I believe that you can right-click in the object pane- and choose
startup options.

Or just choose TOOLS, Startup I think that it's just called that...

and then just uncheck the box that says 'display database window'

PS - if you're using SQL Server; are you using ADP? Should you be?

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Roger Carlson]

Under Tools>Options, make sure "Windows In Taskbar" is unchecked.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Rohn Everson]

Thanks Roger,

I did uncheck the "Windows In Taskbar" also. I am sure it is related to
the switchboard that I copied from a Microsoft Template but I can't seem to
get rid of the control over the database window. Its a small nuisance in
the bigger scheme of things!

 

[aaron.kempf]

wait a second. There is an option on the switchboard to 'see the
database window' right?

Perhaps you should just remove the switchboard item that you dont'
want to see?

-Aaron

 

[Rohn Everson]

Aaron and others,
Not knowing enough about codes and programming the switchboard does have
this control:
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize


So I replaced the "DoCmd.Minimize" with "Docmd.RunCommand acCmdWindowHide"
which I found at http://www.mvps.org/access/general/gen0031.htm.

Thanks for the help in looking for what is UNHIDING it programmatically!
This sites help is priceless!

Rohn

I still don't get the problem.

You say that the checkbox is set to unchecked-- the one that says
'display db window'.

And the db window is still showing up? Sounds to me like you are
currently _UNHIDING_ it programmatically.
So I'd undo the unhide instead of hiding again

-Aaron

Thanks again Aaron,

ADP looks like it will make the database run even better. On the other
issue, any ideas how to change the database window to hidden now that I am
using this switchboard. In looking at the code (which I know very little
about) its Event Procedure says: DoCmd.Minimize can I tell it to
DoCmd.Hide
or DoCmd.NoShow or something?

Code look like this:

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.Minimize

' 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


Under the File Menu, Select New, and then 'Project (existing data)'.

Type in your server name.
Your db name.

Right click import all your forms. Presto-chango-- you've got all
your queries where they belong (ON THE DATABASE SERVER).

PS - i'd reccomend using Access 2007 with SQL 2005 or Access 2000-2003
works _GREAT_ with SQL 7.0, 6.5 and 2000.

Thanks Aaron,

I do have the 'display database window' unchecked. Which this worked
fine
when I was just displaying one form. I now have three different forms
and
now using a switchboard and the database window is now only minimized,
not
hidden even though the box is unchecked?

I am not sure what ADP is, but the backend is on our SQL server!

thanks again, Rohn

<[email protected]> wrote in message

I believe that you can right-click in the object pane- and choose
startup options.

Or just choose TOOLS, Startup I think that it's just called that...

and then just uncheck the box that says 'display database window'

PS - if you're using SQL Server; are you using ADP? Should you be?

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[a a r o n . k e m p f]

yes; I typically take the extra step-- so that if someone closes the
Switchboard; then it will automatically go to the db window; select a
macro that is called 'restart switchboard'.

This way-- you give an abstraction layer (and it is usually one of the
only 2 macros I ever use-- the other being autoexec)

the punchline- you make autoexec _ALSO_ call the 2nd macro (which only
launches the switchboard).

Not to minimize thigns.. but effectively; if someone _CLOSES_ the
switchboard; it will stick them pointing to the MACROS and select that
macro I have that is called 'Restart Switchboard'.

I learned this from this wizard I know named Wayne.. Had to give a
quick shout out-

-Aaron

Aaron and others,
Not knowing enough about codes and programming the switchboard does have
this control:
     DoCmd.SelectObject acForm, "Switchboard", True
     DoCmd.Minimize

So I replaced the "DoCmd.Minimize"  with  "Docmd.RunCommand acCmdWindowHide"
which I found athttp://www.mvps.org/access/general/gen0031.htm.

Thanks for the help in looking for what is UNHIDING it programmatically!
This sites help is priceless!

Rohn


I still don't get the problem.

You say that the checkbox is set to unchecked-- the one that says
'display db window'.

And the db window is still showing up? Sounds to me like you are
currently _UNHIDING_ it programmatically.
So I'd undo the unhide instead of hiding again

-Aaron

Thanks again Aaron,

ADP looks like it will make the database run even better. On the other
issue, any ideas how to change the database window to hidden now that I am
using this switchboard. In looking at the code (which I know very little
about) its Event Procedure says: DoCmd.Minimize can I tell it to
DoCmd.Hide
or DoCmd.NoShow or something?

Code look like this:

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.Minimize

' 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

<[email protected]> wrote in message

Under the File Menu, Select New, and then 'Project (existing data)'.

Type in your server name.
Your db name.

Right click import all your forms. Presto-chango-- you've got all
your queries where they belong (ON THE DATABASE SERVER).

PS - i'd reccomend using Access 2007 with SQL 2005 or Access 2000-2003
works _GREAT_ with SQL 7.0, 6.5 and 2000.

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Tony Toews [MVP]]

ADP looks like it will make the database run even better.

Possibly. However ADPs have not been enhanced in any way in the last
version or two of Access whereas MDBs/ACCDBs have had many
improvements.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Dude you are such a con artist!

Where do you get off with bllshit like this?

Have MDBs been enhanced? NO. Dao wasn't included in 2 versions of
Office; the past 3 versions of MDAC. What kind of scam bullshit are
you talking about? Please point to me -- _ONE_ thing that has been
improved in MDB that wasn't added to ADP?

Please-- oh mister great MIS-INFORMER

Have ADPs been enhanced? -- YES --
SQL 2005.
UDFs for SQL 2000
DTS -> SSIS
Reporting Services
Analysis Services

SQL Server has improved 30,000 percent in the past 7 years.

Are ACCDBs laced (tainted) with SharePoint going to make me happy?
HELL NO

 

[aaron_kempf]

MDBs haven't gotten any helpful improvemtns since about 1993.

-Aaron

 

[Tony Toews [MVP]]

MDBs haven't gotten any helpful improvemtns since about 1993.

Totally false.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

MDBs haven't gotten any helpful improvemtns since about 1993.

-Aaron