Group:  Microsoft Access ยป microsoft.public.access.security
Thread: Programatically hide and unhide the database window

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Programatically hide and unhide the database window
Patrick 14.07.2006 15:46:02
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
Re: Programatically hide and unhide the database window
John Mishefske <jmishefskeNO[ at ]SPAMyahoo.com> 14.07.2006 23:17:07
Patrick wrote:
[Quoted Text]
> 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
'---------------
Re: Programatically hide and unhide the database window
Patrick 25.07.2006 21:00:02
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" wrote:

[Quoted Text]
> 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
> '---------------
>
Re: Programatically hide and unhide the database window
John Mishefske <jmishefskeNO[ at ]SPAMyahoo.com> 26.07.2006 02:01:22
Patrick wrote:
[Quoted Text]
> 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
'---------------

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net