Programmatically edit object groups

[Danny]

From the main database window the user can create object
Groups, and add, edit, and delete objects in those groups.
The objects in the groups are actually shortcuts to the
original objects listed under the system-default groups -
Tables, Queries, Forms, etc..

My question is: Can object groups and their members be
manipulated using VBA? If so, how so?

Thanks so much for the help.

Danny

 

[Amanda Payton]

Danny -

Yes! there is very little (if anything) that you can manipulate in the
standard Access interface that you cannot manipulate with VBA.

Tables/Queries, Forms, Reports, Relaionships, etc. are groups called
"Containers"
and every Table, Form, Report and Relationship that you create is a
"Document" in it's respective container. VBA can handle Containers and
Documents in very very similar ways to any other object, and you can cycle
and scroll through the members, as well as manipulate them.

I reccommend picking up a book on programming VBA for whatever version of
Access you have, and look at what it has to say about containers and the
object hierarchy. You will be able to get a lot more detail and examples
than I'm able to use here.

HTH

Amanda