Chapter Summary

In this chapter, you learned how to test your VBA procedures to make sure they perform as planned. You debugged your code by stepping through it using breakpoints and watches, learned how to work with the Immediate window in break mode, found out how the Locals window can help you monitor the values of variables, and discovered how the Call Stack dialog box can be helpful in keeping track of where you are in a complex program. You also learned how to specify the parts of your procedure that you want to include or exclude upon compilation. Finally, you learned how to trap errors with error-handling routines. By using the built-in debugging tools, you can quickly pinpoint the problem spots in your procedures. Try to spend more time getting acquainted with these tools. Mastering the art of debugging can save you hours of trial and error.

PART II

Creating and Manipulating Databases with ADO

ActiveX Data Objects (ADO) is a set of programming objects that enable client applications (including Microsoft Office Access) to access and manipulate data through an OLE DB provider.

In this part of the book, you learn how to access ADO objects in your VBA code to connect to a data source; create, modify, and secure database objects; and work with data.

Chapter

10

Chapter

11

Chapter

12

Chapter

13

Chapter

14

Chapter

15

Chapter

16

Chapter

17

Chapter

18

Accessing Data Using ADO

Creating and Accessing Tables and Fields with ADO

Setting up Indexes and Table Relationships with ADO

ADO Techniques for Finding and Reading Records

Working with Records

Creating and Running Queries with ADO

Using Advanced ADO Features

Implementing Database Security with ADOX and JRO Database Replication

Chapter 10

0 0

Post a comment