List report name and record source

[Donna]

I have a query that lists all reports, but I don't know how to list the
record source with the name since that field is not part of the hidden system
table. I know I can use the documentor function, but it lists a single report
per page and I have over 1,000 reports. I know I could output it to Word and
search and replace, but is there a simpler way? We are trying to cleanup the
database by deleting reports, but then we also need to delete the record
source (query) as well.

 

[Duane Hookom]

You can use the documenter to display your reports and data properties. Then
follow the instructions at http://www.access.hookom.net/Documenter/ to
connect to the results. Use the following sql in a query to display just the
report names and record sources:

SELECT doc_tblObjects.Name AS ReportName,
doc_tblObjects_1.Extra1 AS RecordSource
FROM doc_tblObjects AS doc_tblObjects_1
INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID = doc_tblObjects.ID
WHERE doc_tblObjects_1.Name="RecordSource:";