Programatically hide and unhide the database window

[Patrick]

Hey!

I don't know if this is the appropriate place, but I've looked and can not
find a vba way to hide and unhide the database window?

Can anyone point me in the right direction?

Thank you!

Patrick

 

[John Mishefske]

Hey!

I don't know if this is the appropriate place, but I've looked and can not
find a vba way to hide and unhide the database window?

No, it isn't the right group. comp.databases.ms-access would have been a good group to ask.

http://www.mvps.org/access/general/gen0031.htm

You can display the Database window by using the SelectObject:

DoCmd.SelectObject acTable, , True

and you can hide it using a DoCmd.RunCommand:

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

I believe there is code to determine if the DatabaseWindow is open here:

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

 

[Patrick]

Thank you!

How would I find

"comp.databases.ms-access "

It doesn't appear in the communities window [at least that I can find] on
the support site. . .

Thank yoU!

 

[John Mishefske]

How would I find

"comp.databases.ms-access "

It doesn't appear in the communities window [at least that I can find] on
the support site. . .

"comp.databases.ms-access" is a UseNet group. I assumed you accessed this UseNet group
using a News reader software of some type. You would use that software to list the news
groups, find that one and subscribe to it.

If you are using a web browser then you might try the archives at Google Groups:

http://groups.google.com/group/comp.databases.ms-access?hl=en&lr=&ie=UTF-8