Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to change the hidden attribute of an MS Access table programatically

Posted on 2011-03-15
5
Medium Priority
?
596 Views
Last Modified: 2013-11-27
I import a table into my MS Access database from another MS Access database using  the "DoCmd.TransferDatabase" and the table arrives as hidden.  I need a way to programatically change the hidden status either on the way in, or after it arrives to allow subsequent work.
0
Comment
Question by:tomlewis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35143561

to unhide a table

currentdb.tableDefs("tablex").attributes=0  
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 35143624
to unhide a table

currentdb.tableDefs("tablex").attributes=0  

to refresh the database object window

application.refreshDatabaseWindow
0
 
LVL 75
ID: 35144716
Interesting ... that property appears to be independent of the Hidden Objects setting in Options ... see below.

In case you actually want to hide a table, you can use:

CurrentDb.TableDefs("Table1").Attributes = dbHiddenObject

mx


Capture1.gif
0
 
LVL 75
ID: 35144738
dbHiddenObject = 1
0
 

Author Closing Comment

by:tomlewis
ID: 35162760
Thanks much!!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question