By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Close database window

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a

"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

P: n/a
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.