Setting the 'hidden' property of objects

[gyma]

Is there a way to set the 'hidden' property of all objects to true? I do this manually as an extra security measure for some distributed apps I work with. Would greatly appreciate some sageful advice.

Jim :{ X-)

 

[kathryn]

Jim,

Check out these help topics:

Set Options from Visual Basic
GetOption, SetOption Methods
GetOption, SetOption Methods Example

I think that is what you are looking for.



Kathryn

 

[HIM]

You can change the .Visible attribute to false for any control, and this will hide it.

 

[gyma]

THANKS for the responses, Kathryn and HIM.....to be more exact, here's what I am looking for- a procedure that would make all objects -(tables,queries,forms,reports and modules) not visible in the database window. I've had limited success in using the SetOption code.

Thanks again_

jim

 

[kathryn]

Could you be more specific about your problems with SetOption? That is the only was that I know of to hide objects in the window.

There is a way to hide the window and disable the shortcut to bring it back. Would that work?

Kathryn

 

[Hmadyson]

What exactly is the syntax for hiding a report? I am looking through help for SetOption and it only mentions the properties in the Options dialog. Please give an example of hiding a report named "Temp" using your method.