import objects

[abenitez77]

I want to export different objects (i.e. modules, reports,tables, queries...) from another ms access application. How can I list the objects so I can pick from them and then import them. I know ms access has a wizard and I am looking to do the same but a little different because I have an application that I want to filter my objects by a criteria.

 

[MarkK]

Check out the hidden system table called MSysObjects. There is a record in that table for every object in your database, and it'd be easy to use that record source for a user interface selection tool.

For simplicity, create a query with this text . . .

SELECT * FROM MSysObjects

. . . and just open that query, and you can see what I'm talking about.

Hope this helps,

 

[smig]

You should Import the objects into the other DB not exporting them.
From the other DB use Import, select the DB you want to Import from and select the objects you want to Import.

 

[abenitez77]

Check out the hidden system table called MSysObjects. There is a record in that table for every object in your database, and it'd be easy to use that record source for a user interface selection tool.

For simplicity, create a query with this text . . .

SELECT * FROM MSysObjects

. . . and just open that query, and you can see what I'm talking about.

Hope this helps,

Yes, this is very helpful. Thanks!