Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hiding tables using SQL or DAO, or all new tables with hide default

Status
Not open for further replies.
cani

cani

MIS
May 10, 2002
17
0
0
BM
Good day!

Does anyone know how to do one of the following:

1) Use SQL to hide a table so that it does not appear in the database window
2) Use DAO to hide a table; or
3) Adjust a database setting so that all forms, tables, macros, reports, etc., that are created have the hide property attribute default to "hide" when they are created?

I'm trying to avoid manually setting the property attribute to hide on every object that is created.

 
Status
Not open for further replies.

Similar threads

Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
76
Dan Stoica
Dan Stoica
aldi07
  • Locked
  • Question
update a front-end database with a new release using vba
Replies
5
Views
99
aldi07
aldi07
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
67
combo
combo
Moss100
  • Locked
  • Question
Hiding or resizing Access Application so my pop up form is all that is seen by the user
Replies
2
Views
72
jedraw
jedraw
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
135
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top