Darren DICK
d.dick at uws.edu.au
Mon Aug 2 06:45:26 CDT 2004
Hello all The following code hides all the tables in a dB- cool and it works well But there seems to be no "dot attributes" (.Attributes =) setting for Queries from the QueryDefs object I basically wanna run some enumerating code like below and hide queries, forms etc Any ideas? Many thanks Darren Function f_HideAllTables () Dim db As DAO.Database Dim tbl As TableDef Set db = CurrentDb() For Each tbl In db.TableDefs tbl.Attributes = 2 Next Application.RefreshDatabaseWindow end function