• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

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

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
sbornstein2
Asked:
sbornstein2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can use the built in Database Documenter to do this.

1
2
3
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
hnasrCommented:
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
 
sbornstein2Author Commented:
this is all I wanted perfect thanks
0
 
hnasrCommented:
Welcome!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now