472,101 Members | 1,529 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,101 software developers and data experts.

Close database window

If I have a form open and the database window is open, is there a command I
can use from an on click event that will close the database window for me,
but still leave the application open?

dixie
Nov 12 '05 #1
4 9721
Dixie,

I copied these notes from Access' Help. You can have the database open with
the Database Window hidden.
Would this process do what you need? Then you can always show the Database
Window by hitting F11.

HTH. Linda
Display or hide the Database window when an Access database or Access
project opens.
1.. On the Tools menu, click Startup.

2.. Clear or select the Display Database Window check box.
Notes

a.. Changes to this setting in the Startup dialog box won't take effect
until the next time the Microsoft Access database or Microsoft Access
project is opened.
b.. If you don't display the Database window, you need to display a form
or data access page that others can use to navigate in your Access database
or Access project. For more information, click .
"dixie" <di****@dogmail.com> wrote in message
news:6l*****************@nnrp1.ozemail.com.au...
If I have a form open and the database window is open, is there a command I can use from an on click event that will close the database window for me,
but still leave the application open?

dixie



Nov 12 '05 #2
Thanks Linda, but this is not what I am looking for. I have a hidden button
that will display the database window for a person authorised to do so and I
want them also to be able to close it from withing the application after
they have opened it. I have the shiftkey disabled at start up (not that
this keeps determined people out, but it works for a lot of "fiddlers".

dixie

"Squirrel" <wi*****@covad.net> wrote in message
news:93***************************@msgid.meganewss ervers.com...
Dixie,

I copied these notes from Access' Help. You can have the database open with the Database Window hidden.
Would this process do what you need? Then you can always show the Database Window by hitting F11.

HTH. Linda
Display or hide the Database window when an Access database or Access
project opens.
1.. On the Tools menu, click Startup.

2.. Clear or select the Display Database Window check box.
Notes

a.. Changes to this setting in the Startup dialog box won't take effect
until the next time the Microsoft Access database or Microsoft Access
project is opened.
b.. If you don't display the Database window, you need to display a form
or data access page that others can use to navigate in your Access database or Access project. For more information, click .
"dixie" <di****@dogmail.com> wrote in message
news:6l*****************@nnrp1.ozemail.com.au...
If I have a form open and the database window is open, is there a command
I
can use from an on click event that will close the database window for

me, but still leave the application open?

dixie


Nov 12 '05 #3

"dixie" <di****@dogmail.com> wrote in message
news:wj**************@nnrp1.ozemail.com.au...
Thanks Linda, but this is not what I am looking for. I have a hidden button that will display the database window for a person authorised to do so and I want them also to be able to close it from withing the application after
they have opened it. I have the shiftkey disabled at start up (not that
this keeps determined people out, but it works for a lot of "fiddlers".

dixie

You can't close that window - that would close the database. Instead, you
hide it:

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
Fletcher
Nov 12 '05 #4
Thanks Fletcher, thats the one I want.

dixie

"Fletcher Arnold" <fl****@home.com> wrote in message
news:c1**********@titan.btinternet.com...

"dixie" <di****@dogmail.com> wrote in message
news:wj**************@nnrp1.ozemail.com.au...
Thanks Linda, but this is not what I am looking for. I have a hidden button
that will display the database window for a person authorised to do so

and I
want them also to be able to close it from withing the application after
they have opened it. I have the shiftkey disabled at start up (not that
this keeps determined people out, but it works for a lot of "fiddlers".

dixie

You can't close that window - that would close the database. Instead, you
hide it:

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
Fletcher

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by RonS | last post: by
4 posts views Thread by Sjaakie Helderhorst | last post: by
1 post views Thread by Alpha | last post: by
2 posts views Thread by richard | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.