Contents
- Index
- Previous
- Next
Step 3: Find "Uses" Dependencies
You can find two kinds of dependencies: Used By (described in the previous page), and Uses (described here).

What is a 'Uses' Dependency?
- It is a kind of "bird's-eye view" of the principal objects used by queries, forms, reports, and modules.
- Here are the specifics:
- Queries - A layered query is a query based on another query. These can go multiple levels deep, and to open up queries in the different layers used to be cumbersome Now, in one place you will see listed every "lower-level" query and/or table (conveniently numbered) -- with one-click access to each of them.
Note: The 2 checkboxes specifically apply to queries, and are described below.
- Forms and Reports - Instantly view the record source and sub forms/sub-reports used by them -- with one-click access to each.
- Modules - Instantly see every sub and function contained in your modules -- with one-click access to each of them.
How to do it?
- It's very simple. On the main form, click on the Dep's button for the object you want to search for. The form above will come up.
- Be sure Find Uses Dependencies is selected. This is normally a very quick operation.
- To see example results, look further below
Process All Layers? Checkbox
- This is normally selected and specifically applies to Queries.
- If selected, queries and tables in lower levels will be listed until only tables remain.
- If not selected, only the queries and tables in the top level will be listed.
Include Tables? Checkbox
- This specifically applies to queries.
- If selected, then tables will be listed, otherwise, tables will be excluded from the dependency list.
Sample Results Explained
- The Uses results displayed in the sample screen below will now be described.
- We see that the query "Invoices Filter" is based on a query named Invoices (record 3). Records 4 and 5 show us that the query Invoices is itself based on two tables (Shippers and Products). If Invoices had been based on yet another query, then that would have been shown as well. As many levels as are present will be shown, down to the table level.
- When starting the Find Dependencies process, you will have the option to not show tables, and also whether to process all levels (default) or only the top level.
- Of course, you can click on Open, Run, etc. for instant access to all the objects that Invoices Filter depends on.