Is it possible to have more than one Relationships window?

[Helge V. Larsen]

Is it possible to have more than one Relationships Window?
Could windows for instance be made by some VBA code?

As it is now I only have one window that quickly gets very messy.

 

[Allen Browne]

You cannot open the Relationships Window twice in one instance of Access.

There are several possible workarounds:

a) Download this utility from Stephen Lebans:
http://www.lebans.com/saverelationshipview.htm
It allows you to save several relationships views and load them again later.
This makes it easy to switch views, but you still get just one at a time.

b) With the Relationships window open, tap the PrintScreen key. Then open MS
Paint (Start | Programs | Accessories), and paste. This gives you a
"picture" of the screenshot. You can now change the relationships view and
switch between the real one and the picture.

c) Create a Relationships report (Access 2000 and later.) This report can
show one set of relationships, while you view another set in the
Relationships window.

d) Open a backup of your database in another instance of Access. This gives
you two relationships views.

If you want to programmatically manipulate the windows, the link from
Stephen Lebans above is probably a good starting point.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Helge V. Larsen]

Stephen Lebans' utility does not function in Access 2003 SP2: I cannot save
and restore a layout.

 

[Tony Toews [MVP]]

As it is now I only have one window that quickly gets very messy.

But you can scroll around in that window. So the relationship window
can get to be 48" by 48"

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John W. Vinson]

Is it possible to have more than one Relationships Window?
Could windows for instance be made by some VBA code?

As it is now I only have one window that quickly gets very messy.

It's a pain. I usually view the relationships window as a temporary
scratchpad, and - unfortunately - not as a strong documentation tool.

For a large app, the choices are between a huge bedsheet report with different
groups of tables on different areas - and major annoyances adding new tables,
as you can't predict where they'll pop up, other than that it will be an
inconvenient place; or wiping it clear and adding whatever tables you're
interested in displaying on an ad hoc basis.

That's one of the reasons we appreciate people like Stephen writing third
party tools to do what Access should have done; I also am starting to put more
and more databases into SQL backends and using the much more flexible
"Diagrams" feature. You can create any number of independent relationship
diagrams for your tables. Manipulating the position of the join lines is a bit
awkward at times but you can at least get as many diagrams as your database
has (semi)independent modules.

 

[Helge V. Larsen]

Sorry, I do apologize for being too categorically.

The fact that I could not make it function should not have been reported as
if it does not function.

I hoped that the facility allowed me to define e.g. two relations windows
with some tables shown in one window and other tables shown in the other
window. This I could not make it do.

As far as I can see it is possible to define the position of the tables in
the individual relations windows. But all relations windows hold the same
tables. Am I still wrong?