Hiding Tables. Queries, Forms etc

[Dave_cha]

Just wondering if anyone has a quick method of hiding multiple tables, queries etc.

I can go to the properties of each object, one at a time, but this is a pain in the as* and it's not possible to select more than one object at a time.

Maybe there's code out there somewhere which will make all objects hidden when run?

Thanks,

Dave

 

[fuzzygeek]

One way

Programmatically amend "usys" to the beginning name of each object you want to hide. Access will perceive them as system objects and hide them immediately. It's a leftover from Access 2.0 but works in XP. But then you would have to change the names everywhere you use them. Probably take more time than what you're doing now.

 

[tiggy]

Hi Pat

When I use usys on my forms, table and queries the switchboard won't work, is that the bug you are referring to. I am using XP 2002 SP2.

Thanks

Steve

 

[Rich]

Why not just hide the DB window?

 

[Hayley Baxter]

There's a little more information on the bug here

 

[Dave_cha]

Thanks for the help guys. I'll probably go with the hide DB option and then disable windows in taskbar (with 'Windows in taskbar' ticked the db window opens regardless).

Dave