Add Tables to RelationShip-Windows with VBA

  • Thread starter Thread starter Gernot Pfeifer
  • Start date Start date
G

Gernot Pfeifer

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
 
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.
 
The user has to add the tables manually to the window to show the
releations.
Click to expand...

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


Tim F
 
Back
Top