Relationship diagram
in [Form]
|
From: Michael on 17 Apr 2010 16:16 Not sure if this is the correct forum but here goes. I have a problem with the relationships diagram in that one of the tables has slipped off the top of the page somehow. I have scrolled up as far as possible but only the last field can be seen and I do not seem to be able to select the table to move it back into the window again. Has anyone come across this before? Many thanks, Michael.
From: Jeanette Cunningham on 17 Apr 2010 16:52 I have found nearly similar in A2007 (my tables disappeared upwards a bit, but I could always find a small bit of their top to click on to bring them down). This is untested, but I expect that if you clear the relationships window, (the big red X), and add then click 'show all relationships', you will have all the tables back in view. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Michael" <michaelj(a)dsl.pipex.com> wrote in message news:GJSdnaV6AviCilfWnZ2dnUVZ8nydnZ2d(a)pipex.net... > Not sure if this is the correct forum but here goes. > > I have a problem with the relationships diagram in that one of the tables > has slipped off the top of the page somehow. I have scrolled up as far as > possible but only the last field can be seen and I do not seem to be able > to select the table to move it back into the window again. > > Has anyone come across this before? > > Many thanks, Michael. >
From: John W. Vinson on 17 Apr 2010 18:26 On Sat, 17 Apr 2010 21:16:32 +0100, "Michael" <michaelj(a)dsl.pipex.com> wrote: >Not sure if this is the correct forum but here goes. > >I have a problem with the relationships diagram in that one of the tables >has slipped off the top of the page somehow. I have scrolled up as far as >possible but only the last field can be seen and I do not seem to be able to >select the table to move it back into the window again. > >Has anyone come across this before? > >Many thanks, Michael. > In addition to Jeanette's suggestion (which will work but may require some tedious repositioning), try using the keyboard. Set focus to one of the tables, and keep pressing the <Tab> key on the keyboard until it gets to the vagrant table. Delete it (don't worry, it won't delete any relationships, just the table icon) and re-add it. -- John W. Vinson [MVP]
From: Jeanette Cunningham on 17 Apr 2010 19:54 Thanks John, that's a neat trick. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:badks5d3j6u7js4cqftdtj01q7natt09ok(a)4ax.com... > On Sat, 17 Apr 2010 21:16:32 +0100, "Michael" <michaelj(a)dsl.pipex.com> > wrote: > >>Not sure if this is the correct forum but here goes. >> >>I have a problem with the relationships diagram in that one of the tables >>has slipped off the top of the page somehow. I have scrolled up as far as >>possible but only the last field can be seen and I do not seem to be able >>to >>select the table to move it back into the window again. >> >>Has anyone come across this before? >> >>Many thanks, Michael. >> > > In addition to Jeanette's suggestion (which will work but may require some > tedious repositioning), try using the keyboard. Set focus to one of the > tables, and keep pressing the <Tab> key on the keyboard until it gets to > the > vagrant table. Delete it (don't worry, it won't delete any relationships, > just > the table icon) and re-add it. > -- > > John W. Vinson [MVP]
From: Michael T on 18 Apr 2010 14:10 I managed to delete and re-add the table and the relationships came with it so the principle worked thanks. Michael. "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:badks5d3j6u7js4cqftdtj01q7natt09ok(a)4ax.com... > On Sat, 17 Apr 2010 21:16:32 +0100, "Michael" <michaelj(a)dsl.pipex.com> > wrote: > >>Not sure if this is the correct forum but here goes. >> >>I have a problem with the relationships diagram in that one of the tables >>has slipped off the top of the page somehow. I have scrolled up as far as >>possible but only the last field can be seen and I do not seem to be able >>to >>select the table to move it back into the window again. >> >>Has anyone come across this before? >> >>Many thanks, Michael. >> > > In addition to Jeanette's suggestion (which will work but may require some > tedious repositioning), try using the keyboard. Set focus to one of the > tables, and keep pressing the <Tab> key on the keyboard until it gets to > the > vagrant table. Delete it (don't worry, it won't delete any relationships, > just > the table icon) and re-add it. > -- > > John W. Vinson [MVP]
|
Pages: 1 Prev: access 2003 no query results for a form Next: Help Require (Macro Save button )????? |