Close database window - Microsoft Access / VBA

dixie

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

Subscribe Post Reply

9833

Squirrel

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

dixie

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

Fletcher Arnold

"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

dixie

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

Similar topics

How to close browser window in PHP?

by: RonS | last post by:

Is there a way to close the present (active) window using PHP code?

PHP

Close popup from next page

by: Sjaakie Helderhorst | last post by:

Hi, I wrote an ASP-page which allows friends to upload a datafile which will be processed and stored in a database. Because large files take some time to process I want to open a popup 'Please...

Javascript

using close window buttons on a refreshed page

by: mcyi2mr3 | last post by:

Hi all I'm new to javascript and im trying to add a close button function to my certain pages of my site. I use this code: <a href='javascript:window.close();'>Close Window</a> to create a...

Javascript

compact on close using docmd.menuitem

by: ColinWard | last post by:

Hello everyone. happy new year. I am trying to code an exit button for my application so that it automatically compacts the database when the user exits the app. Is this necessary or does the...

Microsoft Access / VBA

CMD window will not close after Batch file executes

by: Bill | last post by:

I need help closing a CMD window when it is executed from Access. 1) The batch file is called from Access. 2) Access closes, 3) the batch runs a copy of the access database (creating a backup)...

Microsoft Access / VBA

Help with access code to close a window

by: bpaff | last post by:

Can anyone help me, I am trying to add a close statement to a procedure to close the current and then open the next window. I am working with command8 below. Option Compare Database Private...

Microsoft Access / VBA

Help! My window application won't close.

by: Alpha | last post by:

I have a Window based application that shows up still running in the task manager when I close it. It reaches the "this.close" statement and then it stops at the "}" at the section of the...

C# / C Sharp

Close API Fonts

by: richard | last post by:

Help with with the API - Calling Windows Choose Font Dialog Found on The Access Web http://www.mvps.org/access/api/api0061.htm The code was originally written by Terry Kreft, and modified...

Microsoft Access / VBA

Capturing close operation when we click on window close button..............

by: Nageshwarrao | last post by:

Hi All, I have a window.open() popup.In which I placed an "Close" button.when I Click on that "Close" button it will pass some information to the Database and after that the window will...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing