Relationships Window 97

C

Colin Hammond

The links on my relationship display do not line up correctly. Just a bit
irritating as it is obvious where they should go. Any tips?
 
T

Tony Toews

Colin Hammond said:
The links on my relationship display do not line up correctly. Just a bit
irritating as it is obvious where they should go. Any tips?

I doubt I'm understanding the problem but you can move the tables
around to get things to line up correctly. Or you can delete and
recreate the relationships if they are on the wrong fields.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
C

Colin Hammond

Tony Toews said:
I doubt I'm understanding the problem but you can move the tables
around to get things to line up correctly. Or you can delete and
recreate the relationships if they are on the wrong fields.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm


The problem is just a display malfunction. I suppose I should try
reinstalling Access.
Colin
 
C

Colin Hammond

Tony Toews said:
I doubt I'm understanding the problem but you can move the tables
around to get things to line up correctly. Or you can delete and
recreate the relationships if they are on the wrong fields.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I have now tried reinstalling Access-- still have the problem
 
T

Tony Toews

Colin Hammond said:
The problem is just a display malfunction. I suppose I should try
reinstalling Access.

Please explain the problem in more detail then.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
C

Colin Hammond

Tony Toews said:
Please explain the problem in more detail then.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Thanks for you interest Tony
The problem is that the lines appear in the wrong position. For example if I
look at the Northwinds relationship diagram. The link from suppliers goes
from the title bar above the list of suppliers to product name in the
products list. Similarly the title bar of Categories is connected to
supplier ID in the products table.

Colin
 
T

Tony Toews

Colin Hammond said:
Thanks for you interest Tony
The problem is that the lines appear in the wrong position. For example if I
look at the Northwinds relationship diagram. The link from suppliers goes
from the title bar above the list of suppliers to product name in the
products list. Similarly the title bar of Categories is connected to
supplier ID in the products table.

Now that is truly bizarre. I've never seen that and don't ever
recall any postings along those lines.

I'd suspect a video card driver problem. Have you got the latest
drivers? If you do have the latest drivers then try installing the
last set of Microsoft certified Windows drivers.

(The certification process costs $ so at least one vendor only
certifies the drivers every six months or so but they come out with
new releases ever month or two. At least this was the case a year or
two back.)

Now, not that I don't believe you but could you email me a print
screen of the relationships window? Insert it into a Wordpad and
fire it off to tony at granite.ab.ca. And zip up a copy of your
Northwinds and send it off to me as well.

Also do you have SR-2 and Jet 3.5 SP3 installed?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
J

Joan Wild

Colin Hammond said:
PMFJI, but what you are seeing (line from the title bar); you need to
scroll up in that table displayed. For example, since/if Supplier ID
isn't visible, the line will appear to come from the title bar.
Scroll up in the Categories table and you'll see the line then come
into view in the proper place.

FWIW, I always resize the tables in the relationship view so that they don't
have scrollbars.
 
C

Colin Hammond

Joan Wild said:
FWIW, I always resize the tables in the relationship view so that they
don't have scrollbars.
If only it were that simple!
Obviously not an Access problem but I will post if I ever find the solution.
 
A

ambradnum

What version of Access?

Could you also email me a print screen of the relationships window and
a zipped copy of your Northwind db.

Regards
Alan
 
T

Tony Toews

Joan Wild said:
FWIW, I always resize the tables in the relationship view so that they don't
have scrollbars.

Yeah, but I have a number of very normalized tables for which I can't
make the tables any taller.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
A

ambradnum

Hallo Colin

Sorry to take so long to reply - living in Zimbabwe is stressful at the
moment and I had other things on my mind!!

I had a look using Access 97. I also had the problem with the
relationships diagram. When I deleted the relationship with the
Suppliers table and recreated it the problem went away. I don't know
what caused it in the first place - I'll keep investigating.

Regards
Alan
 
Top