Results 1 to 2 of 2
  1. #1
    lamphan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    1

    Display table

    hello.

    I was given a access database which was designed to use as a CRM system to manage customer info for the company. My company is using access 2010. When I open the database, there are only forms. I was able to look into the relationship and see many table behind. The problem is I can't have those tables displayed on the left side to start building queries.

    Would anyone help me how to get those tables displayed?


    thanks

    Lam

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Could be the Tables section is simply collapsed. Or individual tables or the Tables section as a whole are set as hidden and the 'Show Hidden Objects' property of the Navigation pane is not checked.

    Right click on the 'All Access Objects' bar and select Navigation Options the make sure 'Show Hidden Objects' is checked.

    Does the Tables section now display? Is it 'greyed out'? Right click the Tables bar.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 07-24-2012, 07:50 PM
  2. Display something from table
    By smarty84handsome in forum Reports
    Replies: 15
    Last Post: 02-13-2012, 12:28 AM
  3. How do you make a text box display a value from a table?
    By italianfinancier in forum Reports
    Replies: 3
    Last Post: 06-01-2011, 12:15 PM
  4. how to display a table into vba forms?
    By sunny in forum Access
    Replies: 1
    Last Post: 07-11-2010, 04:33 AM
  5. Display table on a form
    By vCallNSPF in forum Forms
    Replies: 1
    Last Post: 01-17-2010, 08:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums