Unhiding the Database Window

G

Guest

I have hidden the database window on startup, by unchecking the box in tools
startup. I assume it is just hidden and I want to turn the visibility back on
using VB. I don't know the name of it. My guess of

databasewindow.visibility = true, did not work.

What do you call this thing? and how could I have found this out myself?

Thanks again.
 
R

Rick Brandt

apollo8359 said:
I have hidden the database window on startup, by unchecking the box in tools
startup. I assume it is just hidden and I want to turn the visibility back on
using VB. I don't know the name of it. My guess of

databasewindow.visibility = true, did not work.

What do you call this thing? and how could I have found this out myself?

There is no *direct* way, but this will do it...

DoCmd.SelectObject acTable, "AnyTableName", True

How: The final argument indicates to select the object "in the db window". If
the db window is hidden it must be shown to satisfy that argument.
 
G

Guest

Thanks Rick, that worked, little wierd that you can't reference it, but I'll
take the workaround.
 
D

Dirk Goldgar

Rick Brandt said:
There is no *direct* way, but this will do it...

DoCmd.SelectObject acTable, "AnyTableName", True

How: The final argument indicates to select the object "in the db
window". If the db window is hidden it must be shown to satisfy that
argument.

For what it's worth, you don't have to specify a table. You can leave
that argument out:

DoCmd.SelectObject acTable, , True
 
G

Guest

Thanks, Dejan,

i am also looking for a solution with the same problem (some colleague have
hidden the DB window)
What i am sure of, there is a combination of .... key while doubleclicking
to the mdb file (opening it WITH the DB window and also with the preferences)


thanks & regards,
ANdras
(Hungary)
 
G

Guest

Thanks again, SusanV,
however, this does not work, for any reason (i also recalled to this method,
tried it and failed...)
i use Access2003

Thanks a lot, ANdras
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top