make an access object unvisible with VBA

  • Thread starter Thread starter TNL
  • Start date Start date
T

TNL

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

Thanks
TNL
..
 
me.objectname.visible = False
or
Forms!myform!objectname.visible = False
 
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
 
To hide a table definition in VBA you can use:
CurrentDB.TableDefs("TableName").Properties("Attributes")
=dbHiddenObject
Click to expand...

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
 
TC said:
dbHiddenObject is an undocumented system property.

It is *not* for what its name implies.
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make an object (query, table ...) unvisible programmatically 1
Hide tables in database window 3
change access option with VBA 1
Exporting an unvisible datagrid to excel C# 2
how to set database password with DAO 4
Wheelmouse in VBA 3
Help combo box 2
Hide rows with conditional formatting 5

Back
Top