[AccessD] Hiding objects programmatically

Charlotte Foust charlotte.foust at gmail.com
Thu Sep 1 23:19:41 CDT 2011


I don't recall, but I would assume so.

Charlotte Foust
On Thu, Sep 1, 2011 at 10:09 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> Wow, thanks for the warning.  I vaguely remember this but never really used
> the hidden property before.
>
> I guess I will set by hand.  Do we think this only apples to tables or
> every database object?
>
>
> John W. Colby
> www.ColbyConsulting.com
>
>
>
> On 9/1/2011 12:55 PM, Heenan, Lambert wrote:
>
>> Heads Up John,
>>
>> I don't know if this bug has been fixed but check this out...
>>
>> http://access.mvps.org/access/**bugs/bugs0036.htm<http://access.mvps.org/access/bugs/bugs0036.htm>
>>
>>
>>
>> Lambert
>>
>>
>> -----Original Message-----
>> From: accessd-bounces@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>[mailto:
>> accessd-bounces@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>]
>> On Behalf Of jwcolby
>> Sent: Thursday, September 01, 2011 10:25 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Hiding objects programmatically
>>
>> For production databases I like to hide all the objects in the design
>> window by setting the property to hidden.  In the properties window (Tools /
>> options / View) I then uncheck Hidden Objects and System Objects.  This just
>> adds another level of obsfucation to the database for the average user.
>>
>> I did this and everything was copacetic.  And then... I run one (several
>> actually) of my databases under 2007 runtime and this database was giving me
>> that crash I discussed awhile back.  I ended up having to import everything
>> into a new database and in doing so the hidden attribute of everything was
>> set to visible.
>>
>> I don't have any code to set that property true / false for every object
>> so I thought I'd ask before I go write one.
>>
>> So, does anyone have code to set the Hidden property of the database
>> objects (tables, forms etc)?
>>
>> --
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>>
>>
>> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>
>>
>>
>>  --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>



More information about the AccessD mailing list