make an access object unvisible with VBA

[TNL]

Hi,
how can I set an access object unvisible with VBA?
I habe access 2000

Thanks
TNL
..

 

[Alex Dybenko]

me.objectname.visible = False
or
Forms!myform!objectname.visible = False

 

[TNL]

Hi,
I don't think a control on a Form, but an object such as a
query, a table on the database window.
on the dialog property we can make them unvisible, but
with VBA?

TNL

 

[TC]

To hide a table definition in VBA you can use:
CurrentDB.TableDefs("TableName").Properties("Attributes")
=dbHiddenObject

All such tables will be *deleted* on the next compact!

This is possibly not what he wants.

dbHiddenObject is an undocumented system property.

It is *not* for what its name implies.

TC

 

[Tim Ferguson]

dbHiddenObject is an undocumented system property.

It is *not* for what its name implies.

It is documented... but I agree it's really stupid. There was a similar
thread hereabouts a week or two ago, where we decided that

Application.SetHiddenAttribute

was the way to go.

All the best


Tim F