detect "hidden" status of Access Object

[ecawilkinson]

hi,

In the database window, it is possible to right-click a table, select Properties from the context menu and then make the object hidden by ticking the 'hidden' checkbox. How is it possible to interrogate the value of 'hidden' in VBA code? The reason I want to know this is that I have a combobox on a form to select a table so that the user can view it in Access runtime. I do not want them to be able to see any of the hidden tables. The must be a way to access this attribute/property.

Thanks,
Chris

 

[boblarson]

Look in the Names column in the MSysObjects table for the table names and in the flags column, if it is 8 then it is hidden.