Hiding Database Objects

[fabby1]

Hi

In the Design windows I usually right click go to properties and click the hidden button.

Is there a way to do this via code for ALL database objects

Regards

Phil

 

[KenReay]

Hi

Try interating through the collection setting .hidden to true



Dim frm as Form

for each frm in Forms
frm.hidden = true
next

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi

Try interating through the collection setting .visible to true



Dim frm as Form

for each frm in Forms
frm.visible = true
next

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[fabby1]

Ken

Thanks for the reply

Maybe I didn't explain myself properly

I want to do this for all Database Object

e.g. Table, Forms, Queries, Report etc.

SO that they are not visible in the Database window

Regards

Phil

 

[PHV]

while in VBE (Alt+F11) open the Object browser (F2) and search it for: AllTables, AllForms, AllQueries, AllReports etc.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

There's a start here thread181-955399 (I think 2000+ version)

Roy-Vidar