MSysObjects Table Help with Object Types

[dpimental]

I am looking to be able to use the MSysObjects table to look at queries, forms and reports and determine what tables / queries they are using.

Is it possible to use this table to look at all the forms or all the reports or all the queries to see what their source is?

David Pimental
(US, Oh)

 

[dhookom]

I'm not sure if you will get all of the properties you want from the msysobjects table. You can however use the Documenter and then link to the table of results with the method at Flexible Reporting of Documenter Results
To display the record sources of forms and reports and the Row Sources of combo and list boxes, create a query like:

SELECT doc_tblObjects.Name, doc_tblObjects_1.Name, doc_tblObjects_1.Extra1, doc_tblObjects_2.Name, doc_tblObjects_2.Extra1, doc_tblObjects_2.Extra2
FROM doc_tblObjects AS doc_tblObjects_2 RIGHT JOIN (doc_tblObjects AS doc_tblObjects_1 INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID = doc_tblObjects.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects_1.ID
WHERE (((doc_tblObjects.TypeID)=2 Or (doc_tblObjects.TypeID)=3) AND ((doc_tblObjects_1.Name)="RecordSource:")) OR (((doc_tblObjects_1.Extra1)="Combo Box" Or (doc_tblObjects_1.Extra1)="List Box") AND ((doc_tblObjects_2.Name)="RowSource:"));

Duane
Hook'D on Access
MS Access MVP