• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Advanced Report Techniques > Viewing Object Dependencies

Viewing Object Dependencies

Microsoft added a wonderful feature to Access 2003 that provides you with the capability to view information about object dependencies. It's called View Object Dependencies. Here's how it works:

1.
To invoke the Object Dependency feature, right-click the report whose dependencies you want to view, and select Object Dependencies. The first time you perform this task for a database, a dialog appears prompting you to update object dependency information for the database (see Figure 10.1). After you click OK, Access updates the dependency information for the database and displays the Object Dependencies window on the right-hand side of the Access desktop (see Figure 10.2).

Figure 10.1. The first time you attempt to display object dependencies within a database, Access prompts you to update dependency information for that database.


Figure 10.2. The Object Dependencies window shows you the objects that depend on the selected object, as well as objects that the selected object depends on.


2.
By default, the Object Dependencies window shows you the objects that depend on the selected object. This is a report (not a subreport), so no objects depend on it. You can click the Objects That I Depend on button to view the objects that the selected object depends on (see Figure 10.3).

Figure 10.3. The Object Dependencies window will also show you the objects that the selected object depends on.


3.
You can click the node of an item to drill down to additional dependencies. In Figure 10.4, you can see that qryClients depends on tblClients. tblClients is a table and has no further dependencies.

Figure 10.4. You can click the node of an item to drill down to additional dependencies.


4.
Close the Object Dependencies window when you are finished viewing and working with object dependencies.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint