Reference to Database Window

[dchendrickson]

I am using Access2002 / XP Pro and working primarily with
ADO structures.

My last post didn't get answered, so I'll try again...

Can someone please guide me as to how to reference the
database window in VBA? I would like to programatically
change the .visible property with code but change the
property of?????

The database window doesn't seem to be a member of the
forms or allforms collections. You can hide it at startup
through the startup wizard and you can make it reappear
with F11, but how do you perform those functions in VBA?

Thanks,

-dc

 

[Rick Brandt]

I am using Access2002 / XP Pro and working primarily with
ADO structures.

My last post didn't get answered, so I'll try again...

Can someone please guide me as to how to reference the
database window in VBA? I would like to programatically
change the .visible property with code but change the
property of?????

The database window doesn't seem to be a member of the
forms or allforms collections. You can hide it at startup
through the startup wizard and you can make it reappear
with F11, but how do you perform those functions in VBA?

You don't need to refer to it. The following two lines will hide the
dbWindow

DoCmd.SelectObject acTable, "SomeTabeName", True
DoCmd.RunCommand acCmdWindowHide

The first line above without the second one will unhide it.

 

[dchendrickson]

Rick,

Thank you very much. That works really slick.

-dc