Results 1 to 7 of 7
  1. #1
    mortonsafari is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2015
    Location
    Brisbane, Queensland, Australia
    Posts
    39

    Database Tools, Database Documenter, Report Record Source

    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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Cottonshirt is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    116
    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.


    Click image for larger version. 

Name:	athletics - reports.jpg 
Views:	22 
Size:	59.4 KB 
ID:	42045


    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

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    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.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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....
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    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....
    Attached Files Attached Files

  7. #7
    mortonsafari is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2015
    Location
    Brisbane, Queensland, Australia
    Posts
    39
    Thanks everyone for your suggestions. I'll see how I go.
    Many thanks,
    Kind Regards
    Mortonsafari

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-09-2019, 12:51 AM
  2. Database Documenter
    By MrS in forum Access
    Replies: 7
    Last Post: 11-10-2017, 04:53 PM
  3. Replies: 3
    Last Post: 06-08-2015, 10:58 AM
  4. Create Database Documenter report using VBA
    By edp428 in forum Programming
    Replies: 2
    Last Post: 12-03-2014, 07:18 PM
  5. Database Documenter - Queries
    By bf4man in forum Access
    Replies: 2
    Last Post: 08-26-2011, 04:17 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums