Query to List Reports and their recordsource

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Is it possible to create a query that will list all the Access reports and
their recordsource?
The database documenter gives too much information. I'm trying to cleanup
queries or tables that are not used.

Thanks,
Dave F.
 
Dave F said:
Is it possible to create a query that will list all the Access reports and
their recordsource?
The database documenter gives too much information. I'm trying to cleanup
queries or tables that are not used.
Click to expand...

I just tested and found the documenter can give you want you want.

When you run it, choose just your reports; click on Options. Choose just
Properties (not Code or Permissions), and choose 'nothing' for sections and
controls. Also click on the Properties button and choose only Data
Properties.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update pass through query of report recordsource 2
List Reports and Associated Recordsource 1
How to Query on a forms custom recordsource? 7
Table Relationships with Queries / Recordsources 1
RecordSource Property 2
Query within a report 1
Can't create a report from my query in Access 1
Multiple Queries to Multiple Reports 1

Back
Top