Database Container Window appears when using OuputTo method.

[DavidG]

I have set the database window option so that the database container
window remains hidden when the database is opened. Everything works
fine. When I call the "doCmd.OutputTo" method in a VBA module, the
container window suddenly appears. I could find no information in the
help files to know if this "side effect" could be prevented, so, I'm
using additional code to hide the container window after the OutputTo
method has completed.

If anyone knows how I can prevent the container window from opening,
please respond to this message.

Thanks in advance.

 

[Allen Browne]

I'm not aware of this side-effect: if anyone else is, we would love to know.

There was a bug in Access 2002, where the Database window would appear at
times it should not if you had the Windows In Taskbar turned on under:
Tools | Options | View
Unchecking that box avoided the problem. I believe it was also fixed in one
of the Office 2002 service packs.

Other than that, it could be a side effect of something else, such as a
SelectObject, SendKeys, or inappropriate DoMenuItem.

 

[DavidG]

Recently I believe I read where someone was having a problem with one
of the output commands and the resolution to the problem was to make
the database window visible. Do you know this to be true or did I
perhaps misread the message?

I resolved the issue by adding code to hide the database window after
the OutputTo command.

Thanks for your comments.

 

[Allen Browne]

David, I'm not aware of any problem with OutputTo that would necessitate
showing the database window.