Free E-Books

)
4. Any procedures that could be called by Procedure B and Procedure C are loaded, as
well as the entire modules containing those potential procedures.
5. And so on and so on. . .
TIP
824
Professional Database Development Part IV
Fortunately for all Access developers, this complete loading of a potential call tree has been
addressed in Access 2007. Access 2007 automatically compiles modules on demand, instead of
loading the entire potential call tree. However, you can turn this feature off, thus making Access
2007 compile all modules at one time. Do this in the Visual Basic for Applications program rather
than in Access. Access 2007 links directly to VBA??™s development environment for working with
Visual Basic code. To check the status of the Compile on Demand option, follow these steps:
1. Select the Modules object type from the Navigation Pane.
2. From the ribbon??™s Create tab, select Module from the Macro drop-down in the Other
group to activate the Visual Basic Development Environment.


Pages:
1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565