Hiding an object via code?

M

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
 
R

Rick Brandt

MChrist said:
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.
Click to expand...

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.
 
R

Rick Brandt

MChrist said:
Rick,

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


Then check help file for GetHiddenAttribute, SetHiddenAttribute Methods
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set tabs in work document 0
Progamatically hide objects 2
Own Powerpoint shape like objects 0
Create form with checkbox les that expand and collapse sections of the form? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
VBA Coding Help for Beginner 0
Object Browser in VBA 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top