Acccess documentation of reports, queries, subqueries, tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to document the data source for a given report/query? My
database has many reports, subreports, tables, queries, subqueries, etc. For
a given report, I would very much like to see a tree structure of where data
comes from. For example a given report uses this query, which again might be
created by a combination of other queries and tables.
Anything better than ALT PRINT in design view and being a detective tracing
the datasources all the way back to the basic tables?
Thanks
 
Well, depending on your programming skill level, this can be done using code.
First you can loop through the Reports collection and retreive the Record
Source. You can then look at the RS string and determine if it is a query or
table name. If it results as a query, you can do further string manipulation
to determine the table names if the From clause of the SQL. Meanwhile, you
can store all this information into an array. I hope this helps.
 
Back
Top