T
TNL
Hi,
how can I set an access object unvisible with VBA?
I habe access 2000
Thanks
TNL
..
how can I set an access object unvisible with VBA?
I habe access 2000
Thanks
TNL
..
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alex Dybenko
me.objectname.visible = False
or
Forms!myform!objectname.visible = False
or
Forms!myform!objectname.visible = False
T
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
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
T
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
T
Tim Ferguson
TC said: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