Solved

Access - is there a way I can get a list of all report record sources, tool etc?

Posted on 2013-12-05
5
318 Views
Last Modified: 2013-12-11
Hello all,

I want to try and get a list of each report in an access database and the record source that is on that report?  Any way to do this with a module script or find tool etc?
0
Comment
Question by:sbornstein2
5 Comments
 
LVL 75
ID: 39700247
You can use the built in Database Documenter to do this.

1
2
3
0
 
LVL 84
ID: 39700602
If that's not sufficient for you you can use the Total Access Analyzer, which is hands-down the best Access documenter I've used:

http://www.fmsinc.com/MicrosoftAccess/Documentation/free-trial.html

There's also Rick Fisher's excellent Find and Replace, which can give you quite a bit of this sort of information:

http://www.rickworld.com/
0
 
LVL 30

Accepted Solution

by:
hnasr earned 240 total points
ID: 39700679
Try this in a command click event in a form: the code lists the Report name and the corresponding record source.

Private Sub cmdCheck_Click()
    Dim ro As AccessObject
    For Each ro In CurrentProject.AllReports
        DoCmd.OpenReport ro.Name, acViewDesign
        Reports(ro.Name).Visible = False
        Debug.Print ro.Name, Reports(ro.Name).RecordSource
        DoCmd.Close acReport, ro.Name, acSaveNo
    Next
End Sub

Open in new window

0
 

Author Closing Comment

by:sbornstein2
ID: 39710583
this is all I wanted perfect thanks
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39710951
Welcome!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now