A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Lower a table lodged above visible relationship window?



 
 
Thread Tools Display Modes
  #1  
Old July 26th, 2006, 03:24 PM posted to microsoft.public.access.tablesdbdesign
lisa110rry
external usenet poster
 
Posts: 5
Default Lower a table lodged above visible relationship window?

One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able to
delete the table because I can't click on it. Can anyone help please?
  #2  
Old July 26th, 2006, 03:33 PM posted to microsoft.public.access.tablesdbdesign
mnature
external usenet poster
 
Posts: 67
Default Lower a table lodged above visible relationship window?

Is the button in the scroll bar, on the right side of the relationships
window, all the way to the top? If it is even slightly below the top of the
bar, you can have problems clicking on the table.

"lisa110rry" wrote:

One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able to
delete the table because I can't click on it. Can anyone help please?

  #3  
Old July 26th, 2006, 03:35 PM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Lower a table lodged above visible relationship window?

In the Relationships window, press the Tab key repeatedly until the problem
table gets focus.

Then press the Del key to delete it.
Save the Changes.
Close the Relationships window.

Open the Relationships window again, and add the table where you want it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"lisa110rry" wrote in message
...
One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and
delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able
to
delete the table because I can't click on it. Can anyone help please?



  #4  
Old July 26th, 2006, 03:43 PM posted to microsoft.public.access.tablesdbdesign
lisa110rry
external usenet poster
 
Posts: 5
Default Lower a table lodged above visible relationship window?

Yes, indeed it is! I've tried all manner of things, including going to the
bottom and extending the length and width of the Relationships Window as far
as I can in case that made my errant table "budge" down. I really need this
because my db has about 50 tables - you can imagine how much knitting between
them! Have you any more ideas?

"mnature" wrote:

Is the button in the scroll bar, on the right side of the relationships
window, all the way to the top? If it is even slightly below the top of the
bar, you can have problems clicking on the table.

"lisa110rry" wrote:

One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able to
delete the table because I can't click on it. Can anyone help please?

  #5  
Old July 26th, 2006, 04:01 PM posted to microsoft.public.access.tablesdbdesign
lisa110rry
external usenet poster
 
Posts: 5
Default Lower a table lodged above visible relationship window?

That sounds like the plan! I'm only concerned how I will know the table has
focus if I can't see it?

"Allen Browne" wrote:

In the Relationships window, press the Tab key repeatedly until the problem
table gets focus.

Then press the Del key to delete it.
Save the Changes.
Close the Relationships window.

Open the Relationships window again, and add the table where you want it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"lisa110rry" wrote in message
...
One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and
delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able
to
delete the table because I can't click on it. Can anyone help please?




  #6  
Old July 26th, 2006, 04:09 PM posted to microsoft.public.access.tablesdbdesign
lisa110rry
external usenet poster
 
Posts: 5
Default Lower a table lodged above visible relationship window?

THANK YOU SIR! All fixed now. Should have thought of it myself, but that's
what this group is for isn't it. Again many thanks.
Lisa

"lisa110rry" wrote:

That sounds like the plan! I'm only concerned how I will know the table has
focus if I can't see it?

"Allen Browne" wrote:

In the Relationships window, press the Tab key repeatedly until the problem
table gets focus.

Then press the Del key to delete it.
Save the Changes.
Close the Relationships window.

Open the Relationships window again, and add the table where you want it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"lisa110rry" wrote in message
...
One of my tables has managed to get above the visible portion of the
Relationships Window. I can't find a way to lower it into the visible
portion. I know I can put another copy of the table on and relink and
delete
the other links (I can see them where they stick out from above the top of
the window - that's how I know which table is stuck) but I won't be able
to
delete the table because I can't click on it. Can anyone help please?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table problem Redwood Database Design 29 April 3rd, 2006 04:58 PM
Primary Keys potter Database Design 11 January 31st, 2006 07:25 PM
Help with relationship plase Rock Database Design 5 July 4th, 2005 03:54 AM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM
Complicated Databse w/many relationships Søren Database Design 7 July 13th, 2004 05:41 AM


All times are GMT +1. The time now is 11:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.