Database Tools, Database Documenter, Report Record Source

[mortonsafari]

In Database Documenter I would like to print a list of Reports and their underlying Record Source.
Is there any way I can easily do this.
Database Documenter doesn't seen to give the underlying Record Source for the Report within the Report Properties.
I am looking to streamline a database and to remove reports (and their underlying tables or queries) which are no longer relevant.
Any help appreciated.
Kind regards



Mortonsafari

[June7]

The intrinsic documenter does not offer any customization of output.

You would have to write your own code to do what you want. If you search, I expect you could find example.

[Cottonshirt]

I use an Add In called ACCESS Dependency Checker

this is a free download you can read about here

and download for free from here

once you have installed the ADD-In it will analyse dependencies in your database. you can run it for specific types of objects, queries, reports, forms, etc.

for reports, it will give you output similar to the attachment which is from an athletics database I maintain.





the screenshot shows, on the left, a report with the sub-reports and queries that feed into it. I have expanded the selection for a couple so that you can see what sort of detail you get.

on the right you can see any forms associated with the reports. in this particular case, the form simply has a button that runs the report which is why the form is shown as having no record source.


good luck with your project,


Cottonshirt

[orange]

In addition to the advice above, Crystal Long (strive4peace) has a Documenter tool. See this link for more info.
She also has youtube videos on this and other Access/Excel topics.

[Micron]

Record source for a report is viewable in the documenter. Is this not what is needed?
It won't give you the full sql of an underlying query, but it does document the table or query name....

[ssanfu]

Attached is my attempt from a few years ago (well, it met my needs).

I cut out all of my dB stuff - I think this should run.

Import all objects into your dB.
Open the form "frmRecordsources".
Click on "Fill Table"
Then click on "zzzrptRecordSources" - this report lists object types and record sources. (note some labels and field names show "form" when it is a report. (Remember, this was for my personal use)
You can also open a different report "zzzzRptList".



The "MDB Documenter" module has kind of a search function - "Sub Test()".
Set the path where you want the text file saved, then set "T" to the term you want to locate.
"t" can be multiple lines IIRC.....


Then there is Sub "DocDatabase()" by Author: Arvin Meyer


Have fun....


@mortonsafari
Apologies. Somehow I used the wrong name for the file...
Corrected now....

[mortonsafari]

Thanks everyone for your suggestions. I'll see how I go.
Many thanks,
Kind Regards
Mortonsafari