Make order in relationships (1 Viewer)

[jaryszek]

Hi Guys,

is there any button to place properly all tables in Access relationships window?

Sometimes when i open i have very big mess there:



Please help,
Jacek

 

[theDBguy]

Hi. Don't think so. When you rearrange and close the window, it should ask if you want to save the layout. That's about it.

 

[MajP]

Un tried but good discussion here from Stephen Lebans.

Access Relationships Window: Proper Layout? - Microsoft Access / VBA

Access Relationships Window: Proper Layout?. Microsoft Access / VBA Forums on Bytes.

bytes.com

​

 

[The_Doc_Man]

It reminds me of my bedroom as a teenager... everything stayed where I dropped it or dragged it until I picked it up and moved it again. And I have never managed to figure out how to programmatically move those items either.

Looks like the Lebans article from Majp at least takes a whack at it. Give that a read.

 

[isladogs]

You could try Stephen Lebans solution in conjunction with this from Allen Browne http://allenbrowne.com/AppRelReport.html

Of course its better to try and keep it tidy rather than clear up once it becomes unmanageable
I normally shrink each form to a very small rectangle just showing the fields with links

 

[Pat Hartman]

If you have SQL server available, you could upsize the database and use the diagramming tool there. You can have multiple diagrams per database so sometimes it makes sense to organize a large schema by function. The diagram window shows you page breaks and you can change the size of the diagrams. For gross layout, you can work with the diagram at 25% so you can move tables around very easily. Then to refine the layout, go as close to full size as you need.

 

[GinaWhipp]

The only way I have found besides moving them yourself is clearing the windows, do not break the relationships, and then click All Relationships. Note, it just makes them all line up, there is no real order to them but at least they are not overlapping each other.

 

[jaryszek]

Thank you Guys!

Oh it is a lot of tests to clear this up !

Best,
Jacek

 

[theDBguy]

Thank you Guys!

Oh it is a lot of tests to clear this up !

Best,
Jacek

Hi Jacek. Good luck with it. Please let us know what you figure out.

 

[The_Doc_Man]

Oh it is a lot of tests to clear this up !

Sadly, anything that is worth doing usually isn't that simple.