Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002

    Unanswered: Table outside scrollable area in relationship view

    Hi, I have tables with fields datatype lookup wizard. In relationship view, Access put doubles of the tables accessed by lookup wizard, but some are outside the scrollable area. Now when I made some other changes in tables, one of my former tables went up outside scrollable area. I tried to search archives without result. Maybe someone has a hint.



  2. #2
    Join Date
    Sep 2002
    South Wales

    Lightbulb Perhaps

    Upping your screen resolution may help perhaps?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Nov 2002
    No, I tried resolution already. But I got htis from Microsoft:

    . Reply (E-mail) Forward (E-mail)

    Subject: Re: Showing Tables in Relationship View
    From: "Sandra Daigle" <> Sent: 3/17/2003 4:01:06 PM

    You can solve this by deleting the table that 'fell off' the relationship
    view. Since you can't see the table to select it, click on one of the
    visible tables. Now using the tab key, slowly tab through the tables, when
    you can no longer see the table with the focus, you'll know you have one of
    the hidden ones selected (sounds strange I know). Hit the delete key. This
    deletes it from the layout but leaves the relationship intact. Now add the
    table back to the layout and repeat for any other missing tables.

    This entire problem is caused when you open a table for design from the
    relationships window, then make and save design changes. I *think* the
    problem was fixed in one of the SPs but I can't recall which.

    Sandra Daigle
    [Microsoft Access MVP]
    For the benefit of others please post all replies to this newsgroup.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts