view multiple tables side by side in Access 2007

S

Susan M

I have been an Access user for over a decade and survived multiple upgrades,
but 2007 may finally break me.

All I want to do is view two tables side by side, not in a query but as two
windows next to each other on the screen. I can find a cascade windows
command, but it is grayed out/not available. I'm sorry if this is a dumb
question, and it is just a case of me not seeing something on the screen, but
any help would be deeply appreciated.

Susan
 
D

Dirk Goldgar

Susan M said:
I have been an Access user for over a decade and survived multiple
upgrades,
but 2007 may finally break me.

All I want to do is view two tables side by side, not in a query but as
two
windows next to each other on the screen. I can find a cascade windows
command, but it is grayed out/not available. I'm sorry if this is a dumb
question, and it is just a case of me not seeing something on the screen,
but
any help would be deeply appreciated.
Click to expand...


There's an option, among the "Current Database" options I believe, to choose
whether you want to view objects as "Tabbed Documents" or as "Overlapping
Windows" (if I remember right). You want "Overlapping Windows".
 
S

Susan M

You are my hero today, that fixed it.

Susan

Dirk Goldgar said:
There's an option, among the "Current Database" options I believe, to choose
whether you want to view objects as "Tabbed Documents" or as "Overlapping
Windows" (if I remember right). You want "Overlapping Windows".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
S

Scott McDaniel

I have been an Access user for over a decade and survived multiple upgrades,
but 2007 may finally break me.

All I want to do is view two tables side by side, not in a query but as two
windows next to each other on the screen. I can find a cascade windows
command, but it is grayed out/not available. I'm sorry if this is a dumb
question, and it is just a case of me not seeing something on the screen, but
any help would be deeply appreciated.
Click to expand...

Click the Office Button - Access Options - Current Database. Check the Document Window Options - Overlapping Windows.
Susan
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
L

Larry Linson

Dirk Goldgar said:
There's an option, among the "Current Database" options
I believe, to choose whether you want to view objects as
"Tabbed Documents" or as "Overlapping Windows" (if I
remember right). You want "Overlapping Windows".
Click to expand...

It has always been a puzzlement to me why they would think that the rigidity
and inflexibility of "tiled" windows and "tabbed" documents were so superior
to the user having the flexibility of arranging their own "cascading" or
"overlapping" windows that they would make "tiled" and "tabbed" the default.
Most Access users of my acquaintance have changed that option as one of
their first "adjustments" to each new release.
 
Top