Programatically hide and unhide the database window

14 Jul 2006 3:46 PM

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

14 Jul 2006 11:17 PM

John Mishefske

Patrick wrote:

> 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

--
'---------------
'John Mishefske
'---------------

25 Jul 2006 9:00 PM

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!

Show quoteHide quote

"John Mishefske" wrote:

> Patrick wrote:
> > 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
>
> --
> '---------------
> 'John Mishefske
> '---------------
>

26 Jul 2006 2:01 AM

John Mishefske

Patrick wrote:

> 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

--
'---------------
'John Mishefske
'---------------