hiding and displaying tables

[Paul James]

I would like to be able to hide a table I created from the users of an
application, but I would also like to make it visible when I'm working in
the database myself. I succeeded in hiding this table but following the
instructions below, which I got from Access online help. But as I explain
further down, once you've hidden the table, these instructions don't provide
a way for making it visible again.

In Access help, it says you can do the following to hide or display a
database object:

Specify whether a database object is hidden or visible
1.. Under Objects in the Database window, click the type of database
object whose properties you want to change.
2.. Click Properties on the toolbar.
3.. Select or clear the Hidden check box.
The Properties button the toolbar, however, is grayed-out until you select a
particular object such as a table. Once you've selected the table, the
Properties toolbar button is active, and you can then click on it to select
the Hidden check box. But once you've hidden the table, there's no way to
select it to open the Properties dialog to deselect the Hidden check box.

So how do you make a table visible once you've hidden it by clicking it's
Hidden check box?

Thanks in advance.

Paul

 

[Allen Browne]

Tools | Options | View.

Another useful trick without having to mess with the properties is to name
the table starting with USys. Access automatically hides the tables starting
with MSys (the Microsoft System tables) and USys (the User System tables
provided for this purpose).

 

[Paul James]

Thanks, Allen.

Another question: is there a way to adjust those settings in
Tools-Options-View, specifically hiding and displaying "User Objects," in
VBA code?

Thanks again in advance.

 

[Allen Browne]

Application.SetOption("Show Hidden Objects"), True
Application.SetOption("Show System Objects"), True

 

[Paul James]

Great - thanks, Allen.