List report name and record source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:";
 
Back
Top