I need documentation on existing reports and queries of existing d

R

Roberta R

I need to understand how a current db reports were created (behind the scenes
queries and data sources)
 
L

Larry Linson

Roberta R said:
I need to understand how a current db reports
were created (behind the scenes queries and data
sources)
Click to expand...

I don't understand what you mean by "how a current db reports were created".
If you want to know about the data source, open the Report in Design View,
click the upper-leftmost little square, right-click and choose "Properties",
click the Data Tab and look at the RecordSource property (should be a Table
name, a Query name, or an SQL Statement). To determine the source within
the RecordSource of a Control, click on the Control, click the Data Tab, and
view the Control Source. Controls can be calculated, too, and the
expression or Function reference will be in the Control Source, if so.

Have you tried, on the menu, Tools | Analyze | Documenter?

Also, MVP Jeff Conrad has a free tool at
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html.

There are also for-fee, third-party software packages but I don't know that
they'll tell you any more about what you want to know.

Larry Linson
Microsoft Access MVP
 

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

Append Crosstab Query to Existing Table 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Cross Tab Report Vs Dynamic coulmns 0
How do I clear a form? 0
Change data source of existing report 1
Creating a Chart on form from selected data in query. 0
Report runs, but table it references doesn't exist? 2

Top