Hiding an object via code?

[MChrist]

Can someone please show me an example on how to set the hidden property of a
db object like a table or form via code.

Thank you

Mark

 

[Rick Brandt]

Can someone please show me an example on how to set the hidden property of a
db object like a table or form via code.

What version of Access? There is a method that works in all versions, but which
also causes objects hidden by that method to be deleted if the file is compacted
(you obviously don't want that). Newer versions support an alternate method
that really is the equivalent of setting the hidden attribute from the GUI.

 

[MChrist]

Rick,

Thanks for your response. I'm using Access 2000 and/or 2003.

Mark

 

[Rick Brandt]

Rick,

Thanks for your response. I'm using Access 2000 and/or 2003.

Then check help file for GetHiddenAttribute, SetHiddenAttribute Methods