Consulting

Results 1 to 6 of 6

Thread: Solved: Can't view tables/forms in DB

  1. #1
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location

    Solved: Can't view tables/forms in DB

    I have been asked to look into modifying a data base but for some reason I cannot see any of the tables or forms when I open the file.

    I can view the forms individually. There are macros created to navigate throughout the file from form to form. On a particular for I can right click to go to design view, but I cannot view the list of all the forms.

    The code is all unprotected so I can make any changes that are needed.

    How can I bring up this information (refer to picture) for the data base?

  2. #2
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Hi Jake,

    Try going into Tools|Options|View and check "Hidden Objects"

    Let me know if it works.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  3. #3
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Tools is not shown. I tried to cutomize and make a new toolbar. I can add certain drop downs like File, but when I drag over Tools it will not add??

  4. #4
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    1. Did you try holding [Shift] when opening the database to bypass any startup options?

    2. If unsuccessful, have you tried creating a new database and importing all objects?

  5. #5
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    I haven't tried either of those yet. I'll give 'em a shot tomorrow at work.

  6. #6
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Holding down Shift when opening worked.

    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
  •