Hide the database window

[Nick 'The database Guy']

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

[Keith Wilby]

"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

Have you set the startup options?

Keith.
www.keithwilby.com

[Jan]

Are you talking about showing and hiding it in code? I have this old
quote that works for me:

---Posted by Dev Ashish---

General: Show/Hide database window from code

You can hide the database container window by selecting the "Display
Database Window" option under Tools Menu/Startup. However, if you need
to show or hide the window on demand afterwards, you can use one of
these ways.
To show the database window, run
Docmd.SelectObject acTable, , True

To Hide the database window, run
Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide

HTH

Jan
Nick 'The database Guy' wrote:

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

[Nick 'The database Guy']

Off course I have Keith, Jan has given me the information that I wanted
to know.

Keith Wilby wrote:

"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

Have you set the startup options?

Keith.
www.keithwilby.com

[Nick 'The database Guy']

Thanks Jan, thats exactly what I needed to know.

Nick

Jan wrote:

Are you talking about showing and hiding it in code? I have this old
quote that works for me:

---Posted by Dev Ashish---

General: Show/Hide database window from code

You can hide the database container window by selecting the "Display
Database Window" option under Tools Menu/Startup. However, if you need
to show or hide the window on demand afterwards, you can use one of
these ways.
To show the database window, run
Docmd.SelectObject acTable, , True

To Hide the database window, run
Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide

HTH

Jan
Nick 'The database Guy' wrote:

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

[Keith Wilby]

"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

Off course I have

I read your OP very quickly and misunderstood. Not everyone is familiar
with your level of expertise - "How do you go about hiding the database
window *using code*." might have better alerted the casual reader to what
you actually wanted. Even Jan had to ask!

Keith.

[Tim Marshall]

Nick 'The database Guy' wrote:

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables.

If this is an app for others to use, I would very strongly suggest
improving your interface so that it is not necessary to have to go to a
table "to manually add data".

Never let your app users have access to your tables. Unless it is
someone linking to the tables from another mdb for information purposes
only.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Keith Wilby]

"Tim Marshall" <TI****@PurplePandaChasers.Moertheriumwrote in message
news:eb**********@coranto.ucs.mun.ca...

Nick 'The database Guy' wrote:

>How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables.

If this is an app for others to use, I would very strongly suggest
improving your interface so that it is not necessary to have to go to a
table "to manually add data".

Never let your app users have access to your tables. Unless it is someone
linking to the tables from another mdb for information purposes only.

I must admit, I wasn't sure what the OP meant by "The reason for doing this
is sometimes have to manually add data to tables." I didn't know if there
was an "I" or a "users" missing so I assumed it was for his own use. Still
would be an "unusual" design though :-)

Keith.

[Nick 'The database Guy']

I know Tim I agree with you that you should usually never let users
have access to your tables, however I am in a bit of an unusual
situation, for the first thing the database will only used by 1 or at
the most 2 people, also they are very high level users, furthermore
they have demeanded this access and as they are the people who are
paying me it seems a bit 'unwise' to refuse them.

Nick

Tim Marshall wrote:

Nick 'The database Guy' wrote:

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables.

If this is an app for others to use, I would very strongly suggest
improving your interface so that it is not necessary to have to go to a
table "to manually add data".

Never let your app users have access to your tables. Unless it is
someone linking to the tables from another mdb for information purposes
only.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Nick 'The database Guy']

What I could do with now is a piece of code that disables the X in the
database window that we hide.

Jan wrote:

Are you talking about showing and hiding it in code? I have this old
quote that works for me:

---Posted by Dev Ashish---

General: Show/Hide database window from code

You can hide the database container window by selecting the "Display
Database Window" option under Tools Menu/Startup. However, if you need
to show or hide the window on demand afterwards, you can use one of
these ways.
To show the database window, run
Docmd.SelectObject acTable, , True

To Hide the database window, run
Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide

HTH

Jan
Nick 'The database Guy' wrote:

Hi People,

How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!

Hope that I have made myself clear.

TIA

[Keith Wilby]

"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

What I could do with now is a piece of code that disables the X in the
database window that we hide.

AFAIK you can't do that. What you can do is to have code in your main
form's unload and close events (air code, untested):

(unload)
If MsgBox("Exit Application?", vbYesNo + vbQuestion, "Exit
Application") = vbYes Then
Cancel = False
Else
Cancel = True
End If

(close)
DoCmd.Quit

That way, regardless of how you close the db you'll always run the code
provided the form is loaded. This is particularly useful if you're
maintaining a user log.

HTH - Keith.
www.keithwilby.com

[Nick 'The database Guy']

Thanks Keith,

I am maintaining a users log.

The unload event works a treat.

Thanks,

Nick
Keith Wilby wrote:

"Nick 'The database Guy'" <ni***********@eads.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

What I could do with now is a piece of code that disables the X in the
database window that we hide.

AFAIK you can't do that. What you can do is to have code in your main
form's unload and close events (air code, untested):

(unload)
If MsgBox("Exit Application?", vbYesNo + vbQuestion, "Exit
Application") = vbYes Then
Cancel = False
Else
Cancel = True
End If

(close)
DoCmd.Quit

That way, regardless of how you close the db you'll always run the code
provided the form is loaded. This is particularly useful if you're
maintaining a user log.

HTH - Keith.
www.keithwilby.com