Unhide Database Window

[caimito]

Hello to the group. I have been unsuccessful at unhiding the database
window via code. The most I have gotten is to open the unhide dialogue from
a command button on a form, but then I still have to select the datbase from
the dialogue box and click unhide. Is there a more direct method via code?
I use access 2000 but am transitioning to access 2003.

[dixie]

Caimito, try this code to unhide
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Container", acToolbarNo

Then to rehide
DoCmd.SelectObject acTable, , True
DoCmd.ShowToolbar "Container", acToolbarYes

I have the code in a module and I access it via an autokeys macro, which
means that when I hit the right combination of keys, it unhides it, then by
hitting another combination, I can hide it.

dixie

"caimito" <ca*****@optonline.net> wrote in message
news:4l**********************@news4.srv.hcvlny.cv. net...

Hello to the group. I have been unsuccessful at unhiding the database
window via code. The most I have gotten is to open the unhide dialogue
from a command button on a form, but then I still have to select the
datbase from the dialogue box and click unhide. Is there a more direct
method via code? I use access 2000 but am transitioning to access 2003.

[Allen Browne]

Use SelectObject, with True for the InDatabaseWundow argument, e.g.:

DoCmd.SelectObject acTable,,True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"caimito" <ca*****@optonline.net> wrote in message
news:4l**********************@news4.srv.hcvlny.cv. net...

Hello to the group. I have been unsuccessful at unhiding the database
window via code. The most I have gotten is to open the unhide dialogue
from a command button on a form, but then I still have to select the
datbase from the dialogue box and click unhide. Is there a more direct
method via code? I use access 2000 but am transitioning to access 2003.

[Imageek2]

I received two responses and they both were helpful. The selectobject
method single line suggestion was the simplest. Although I tried to use
the longer response I did not find the toolbar "container". To hide the
database window again I simply used the selectobject and used the hide
method. Why didn't MS just include the unhide method as well? Anyway
thanks much for both responses.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[dixie]

Sorry, imagegeek2, the DoCmd.ShowToolbar "Container", acToolbarNo and its
Yes version referred to a specific toolbar on my system. Didn't mean to
confuse you, just didn't think. Brain in neutral lately :-)

dixie

"Imageek2" <no****@devdex.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

I received two responses and they both were helpful. The selectobject
method single line suggestion was the simplest. Although I tried to use
the longer response I did not find the toolbar "container". To hide the
database window again I simply used the selectobject and used the hide
method. Why didn't MS just include the unhide method as well? Anyway
thanks much for both responses.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!