Solved

Unhide tables in Access 2013 Database

Posted on 2015-02-04
1
293 Views
Last Modified: 2016-02-10
We used some vba code to hide some tables in an Access 2013 database.  We can't figure out the code to unhide them.

Here is the code we used to hide them.

Sub HideAll()
CurrentDb.TableDefs("Detail").Attributes = dbHiddenObject
CurrentDb.TableDefs("Intersections").Attributes = dbHiddenObject
End Sub
0
Comment
Question by:upsfa
[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
1 Comment
 
LVL 1

Accepted Solution

by:
upsfa earned 0 total points
ID: 40589535
Never mind.  Found it.
Sub showme()
'CurrentDb.TableDefs("Detail").Attributes = CurrentDb.TableDefs("Detail").Attributes And Not CurrentDb.TableDefs("Detail").Attributes
CurrentDb.TableDefs("Intersections").Attributes = CurrentDb.TableDefs("Intersections").Attributes And Not CurrentDb.TableDefs("Intersections").Attributes
End Sub
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

749 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