Table off window in Design

[Ted Turner 2010]

I copied a query. In the new query's design window, I scroll all the way to
the bottom and see the join lines going out of sight before I see the next
table.
How do I resolve this problem?

 

[Banana]

I copied a query. In the new query's design window, I scroll all the way to
the bottom and see the join lines going out of sight before I see the next
table.
How do I resolve this problem?

That's a first for me.

But I suppose if I were you, I'd switch to SQL view, copy the SQL,
create a new blank query, switch to SQL view and paste the copied SQL
there then switch back to design. By default, the tables should be
arranged by Access.

HTH.

 

[Tom Wickerath]

Hi Ted,

Try copying the SQL (Structured Query Language) statement for the query,
instead of copying the saved querydef itself. Open the source query in design
view. Then flip to SQL view. Select the entire SQL statement and copy it.
Create a new query, dismissing the Add Tables dialog. Switch to SQL view.
Paste your SQL Statement from the clipboard into this new query. Now switch
to design view. This should avoid copying any other saved properties of the
query, such as the layout of the tables.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[John W. Vinson]

On Sat, 2 Jan 2010 12:12:01 -0800, Ted Turner 2010 <Ted Turner

I copied a query. In the new query's design window, I scroll all the way to
the bottom and see the join lines going out of sight before I see the next
table.
How do I resolve this problem?

The SQL solution that Tom and Banana suggest is your best bet - but for this
and other instances (e.g. the Relationships window) where tables can stray
offscreen, one solution may be to use the keyboard. Set focus to a table on
the window and press the <Tab> key to go from table to table. You should
eventually reach the lost sheep and be able to herd it back to the flock.

 

[Tom Wickerath]

Hi John,

Neat trick--I didn't know that one could set focus to a table, and then tab
from table-to-table in query design.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________