Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Thu, 19 Jun 2008 10:04:11 -0700,    group: microsoft.public.access.modulesdaovba.ado        back       


Using VBA how do I access table properties in Access 2007?   
In the Navigation Pane I set a table to hidden using the right click button 
and opening "Table Properties" and then I clicked the "Hidden" checkbox in 
the "Attributes" section to hide it. I can reverse it in "Navigation Options" 
in Access but I can't find anything in the object model in VBA to 
programmatically reverse that or to check its status whether hidden or not. 
Can anybody tell me where to find that in the Object Model?
date: Thu, 19 Jun 2008 10:04:11 -0700   author:   bswearingen

RE: Using VBA how do I access table properties in Access 2007?   
Nevermind, I found it.  I use the "application.GetHiddenAttribute" function.

"bswearingen" wrote:

> In the Navigation Pane I set a table to hidden using the right click button 
> and opening "Table Properties" and then I clicked the "Hidden" checkbox in 
> the "Attributes" section to hide it. I can reverse it in "Navigation Options" 
> in Access but I can't find anything in the object model in VBA to 
> programmatically reverse that or to check its status whether hidden or not. 
> Can anybody tell me where to find that in the Object Model?
>
date: Thu, 19 Jun 2008 13:25:03 -0700   author:   bswearingen

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us