Add Tables to RelationShip-Windows with VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gernot Pfeifer - 30 Oct 2005 18:41 GMT

Hello world (;>)...

I am searching for a code fragment to add Tables to the relationship Windows
with the help of VBA.

I know how to add realations with VBA, I know the way to show them in the
relationship windows.

But:
The user has to add the tables manually to the window to show the
releations.

Is there a resolution to do this with VBA ??

Many thanks and greetings from Germany.

Gernot

Reply to this Message

Allen Browne - 31 Oct 2005 04:13 GMT

The layout of the relationship window is stored in one of the system tables.

Best lead I can give you is this link:
http://www.lebans.com/saverelationshipview.htm
Stephen Lebans has the code there that lets you save and restore multiple
views of the relationship window. By looking at his code, you might be able
to figure out whether you can write to the appropriate system table, and
what values you need to store in which fields.

Signature

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.

> Hello world (;>)...
>
[quoted text clipped - 13 lines]
>
> Gernot

Reply to this Message

Tim Ferguson - 31 Oct 2005 13:04 GMT

"Gernot Pfeifer" <gernotpf@gmx.de> wrote in news:uPLuZmX3FHA.1476
@TK2MSFTNGP10.phx.gbl:

> The user has to add the tables manually to the window to show the
> releations.

The very thought of users looking at the Relationships is enough to make me
run for the gin...

Tim F

Reply to this Message