Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 16Using Advanced ADO/DAO Features

So far you should feel pretty comfortable using ADO in most of your Microsoft Office Access programming endeavors. What’s more, using the knowledge acquired during the last few chapters, you can switch to any other Office application (Excel, Word, PowerPoint, or Outlook) and start programming. Because you already know the ADO methods of accessing databases and manipulating records, all you need to learn is the object model that the specific application is using. Learning a new type library is not very hard. Recall that VBA offers the Object Browser that lists all the application’s objects, properties, methods, and intrinsic constants that you may need for writing code. However, if you’d like to accomplish ...