Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide Tables (2000)

    We are working with a very small group. If I hide a table, how do I make it appear again?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    Tools / Options... / View tab - check the Hidden Objects box in the "Show Section"

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    On the Tools menu, click Options.
    Click the View tab.
    Under Show, select the Hidden objects check box. Microsoft Access displays hidden objects with dimmed icons to distinguish them from objects that aren't defined as hidden.

    Under Objects in the Database window, click the type of database object whose properties you want to change.
    Click Properties on the toolbar.
    Clear the Hidden check box.
    Francois

  4. #4
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    I was "playing around" and right clicked on a table but now I don't know how to make it appear again.

    Right Click - Properties - Hidden

  5. #5
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    Thank you for the reply. You've probably explained it but I'm still a bit confused. Sorry.

    I right clicked on a table, went into the properties, and selected hidden. I just don't know how to make it appear again. It's now hidden so I can't click on it.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    With the database window open, select Tools in the Menu bar, then option, then the Tab View and in the section Show, select the Hidden Objects
    Francois

  7. #7
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    Maybe a visual will help more. The menus are slightly different because I am using Access 2003.
    Attached Images Attached Images

  8. #8
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    THANK YOU, it's back. It kind of looks ghostly; the icon color looks faded. Is that okay?

  9. #9
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    THANK YOU!

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    You still have to right click the table, select Properties and clear the Hidden attribute.
    Francois

  11. #11
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Tables (2000)

    Ah ha! Perfect. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •