asked on

Display tables side X side Access 2007

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?

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

midfde

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

RichNH

ASKER

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

Thank you.

DatabaseMX (Joe Anderson - Former Microsoft 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.

mx