• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

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?
0
RichNH
Asked:
RichNH
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
see image below

mx
Capture1.gif
0
 
midfdeCommented:
Office (Upper Left corner) Button-->Access Options-->Current Database--Overlapping Windows (rather than "Tabbed Documents")
0
 
RichNHAuthor Commented:
You have no idea how much aggrevation that has caused me.  I have looked and looked and never saw that.  Sigh...

Thank you.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now