Access 2003 VBA Programmer's Reference

15.7. Summary

We 've covered a variety of examples that use VBA to transfer information between Microsoft Access and other Office applications. We've covered sending information to Outlook, creating a mail merge in Word, exporting a query to an Excel spreadsheet, and even creating a PowerPoint slide with data sent from Access and then to Excel. You might not perform these exact operations within your application, but the methods and code samples included within this chapter should give you a starting point for further development.

These code samples make extensive use of the object models of each Office Application. If you don't understand the various objects and methods you need in your target application, you'll probably run into problems in your code. Viewing the Help files for the various Office applications will help you understand the objects you want to manipulate.

Next we'll move on to covering the important topic of Security within Access. These days, you can't develop any application without taking into account the various methods of securing your code and access to the data within your application. Chapter 16 should help you cope with this critical task.