Making objects hidden "Randy K." <Randy.Kennedy[ at ]NOSPAM.engineer.com> 29.08.2006 15:31:48 In my .mdb, I use linked tables primarily and many queries, forms, and reports. I like to have them all set as hidden as just another 'security' measure from prying eyes as well as helping me quickly locate the items I am currently still working on (these aren't hidden yet). Is there a VBA routine I could write to recurse the entire collection of items and set them to hidden (primarily the tables because when I relink them, they all change to non hidden). TIA, Randy

Re: Making objects hidden "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 29.08.2006 21:26:35 The command is Application.SetHiddenAttribute acTable,"NameOfTable", True You could loop through the TableDefs collection, or the AllTables collection to get the names of the tables. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Randy K." <Randy.Kennedy[ at ]NOSPAM.engineer.com> wrote in message news:uegl$A4yGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > In my .mdb, I use linked tables primarily and many queries, forms, and > reports. I like to have them all set as hidden as just another 'security' > measure from prying eyes as well as helping me quickly locate the items I > am currently still working on (these aren't hidden yet). Is there a VBA > routine I could write to recurse the entire collection of items and set > them to hidden (primarily the tables because when I relink them, they all > change to non hidden). > > TIA, > Randy >