Relationship window

[wavo99]

Hi,

In the relationship Window i need to add tables to the view using vba. i know how to do it manually but not using vba. Does anyone know how i can do this?

Thanks

[Rabbit]

Why would you need to do this? In a properly designed database, you shouldn't need to do this.

[zmbd]

You do not add tables to the database\tools\relationship via VBA this is as with any of the GUI editors within Access.

Now, if you desire to modify the design of the database, that can be done via VBA; however, as Rabbit has stated, this should not need to be done, nor needed, at run time in a properly designed database.

[wavo99]

Yes I am trying to manipulate something which is why i need to do it this way.

[Rabbit]

We understand that. What we want to know is what you're trying to manipulate and why. And the reason we want to know is because you shouldn't have to do this, you are most likely overcomplicating things and are going about it the wrong way.

[wavo99]

so i am trying to show a relationship view that has a specific amount of tables shown based on the user. So i am going to add and hide tables accordingly. If i can figure out how to set focus to a certain table in the relationship view i can hide the tables that i don't need to see. If i can figure out how to add a table to the view then that would be great too.

[Rabbit]

And why do you need to do this?

[wavo99]

We are trying to create some reports for the user. We created something in access and we want to display the connections. We are using Access in a non conventional way.

[Rabbit]

In what way are you using it?

[wavo99]

we want to display which tables connect are linked to which table. Even if the tables are not linked we want to show the tables.

[Rabbit]

You said you are using Access in a non-standard manner, what is this non-standard manner you are referring to?

[zmbd]

Then what it appears to be that you are actully talking about the report that is generated from the table relationships tool and not the actual tool.

The report can be manuplated to some degree, I've never attempted this myself; however, Allen Browne has done some of this so you should read thru this material and the accompaning code/project:Allen Browne: Relationship Report with extended field information

One thing of note " Stephen Lebans has a utility " mentioned in AB article has not been supported and may very well be broken for ACC2007 and beyond - USE IT AT YOUR OWN RISK.


BTW: Do see how using the proper syntax/grammer/jargon is an imparitive in dealing with programing/databases? If you had started out telling us that you were creating a report based upon the table relationships and needed some help with adding and deleting the tables shown....