Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't access table in Relationship View (off the page)

Status
Not open for further replies.

scottsandford

Programmer
Apr 15, 2002
5
GB
For some reason, between now and last night, when I open the Relationships window - There are three tables that are outside the scrollable area of the viewer!?!? I know this because there are relationships that are drawn between them and other tables.

Is there a way to access those tables?

Is that a way to view the entire layout in a fit-to-page sort of way and then drill down (or zoom) again to the tables I want to deal with?

scott
 

Hi:

I suspect that you could right click on some of the tables that you can see and hide them. Hiding the tables doesn't delete the relationship. Then move other tables to the left (or right) as they become visible. As you see each table re-size it and move it closer to the other tables.
I have a humongous number of tables, some of which are obsolete, I'm sure. I should examine and trash some. But I've never tried to see them all at one time in the relationship view. Gus Brunston [glasses] An old PICKer, using Access2000.
 
I found a work around for this problem (which seems to reoccur...strange). If you open the relationships window with the table that is out of view selected in the tables window in access - then "hide table"; then "Add Table" - it will add it back in an accessible location.

What I don't understand is why something as simple as a "Zoom" feature hasn't been added to this realitively simple feature in Access? Surely it couldn't be that hard to zoom in and out? It would certainly enable designers to have a better layout option for laying out complex designs with space to work in... JMHO

scott
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top