database window won't stay hidden

[Jim]

I have a command button on a form in an Access 2002 front
end which allows administrative users to toggle
the visibility of the database window by changing startup
properties which take effect the next time the
application is opened. I have used two methods to
accomplish this, by using runcommand (DoCmd.RunCommand
acCmdWindowHide) as well as by calling a custom
changeproperty function
(ChangeProperty "StartupShowDBWindow",
dbBoolean, False). Both of these procedures work fine
initially; the db window is indeed not visible when
the application is reopened. When a user minimizes the
application and then reactivates it by clicking on
the application icon in the taskbar, however, the db
window is displayed in all it's glory.

Has anyone else experienced this problem and, if so, is
there a work-around?

 

[Van T. Dinh]

Not sure but try unchecking the "Windows In Taskbar" option.

 

[Jim]

I feel so...duh...

Thanks, Van. That seems to work fine (and also
demonstrates why one should look for the easy answers
first), but it's sure not very secure. Any idea how to do
it from code?

Jim

 

[Van T. Dinh]

Check Access VB Help on the SetOption Method. If I remember correctly, the
name of this option is "WindowsInTaskbar".

 

[zfidjili]

Not sure but try unchecking the "Windows In Taskbar" option.