Is Database Window Open in Access 2003

[Guest]

Is there a way for VBA to check and tell if the Database Window is open. Will
the IsOpen() function do the trick for this window as well as for the other
access objects?

 

['69 Camaro]

Hi, Malcolm.

Is there a way for VBA to check and tell if the Database Window is open.

If Access has opened a database file, then the Database Window is open. If
Access is open without a database file, then the Database Window is closed.
However, even if it's open, it's possible the Database Window isn't visible.
Please see the following Web page for Dev Ashish's code to check whether or
not it's visible:

http://www.mvps.org/access/api/api0069.htm

Will
the IsOpen() function do the trick for this window as well as for the
other
access objects?

The IsOpen( ) function is not a function of any of Access's default
libraries. Test it and if it works, please post the code for your custom
function.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.