Display tables side X side Access 2007

Posted on 2011-04-29
Last Modified: 2012-05-11
I have two tables in an Access 2007 DB,  When I open both of the tables at the same time they each get their own tab and I need to click back and forth between the tabs in order to see the data in the tables.  

What I would like to do is arrange the tables with one on the top part of the screen and the other underneath it so I can view data in both tables at the same time rather than having to click back and forth between the two tabs.  Rather like I could do in Access 2000 by opening windows for both tables and manually sizing/positioning them.

Is there a way to do this via a setting, without having to build a form which displays both tables at the same time?
Question by:RichNH
    LVL 75

    Accepted Solution

    see image below

    LVL 1

    Expert Comment

    Office (Upper Left corner) Button-->Access Options-->Current Database--Overlapping Windows (rather than "Tabbed Documents")
    LVL 1

    Author Closing Comment

    You have no idea how much aggrevation that has caused me.  I have looked and looked and never saw that.  Sigh...

    Thank you.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    It's another case wherein Microsoft added a new feature (cool), BUT ... made it the default setting INSTEAD of the setting that has been around for 18+ years!  I brought this up in the MVP email thread ... with mixed results.  I begged them to make Overlapping the default, but that will probably not happen.

    It's a bad idea to change something that has been in effect for years.  Add the new feature - fine, but keep the default as the original way.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    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…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now