Professional Access 2013 Programming

19

Automating and Integrating with Other Programs

WHAT'S IN THIS CHAPTER?

• Taking advantage of automation using menus, macros, VBA, and more
• Leveraging features in other Office applications from within Access
• Leveraging Access with third-party applications

WROX.COM CODE DOWNLOADS FOR THIS CHAPTER

The code downloads for this chapter are found at www.wiley.com/go/proaccess2013prog.com on the Download Code tab. The code is in the Chapter 19 download in the file 530832_ch19_CodeSnippets.txt. Each snippet is listed sequentially and under the respective chapter heading. You can also get the code from the chapter's demo database, ch19Automation.accdb.

OVERVIEW OF INTEROPERABILITY

Many Access developers have become experts in working with Access for specific purposes but have little or no experience with using Access to automate other programs. However, as work processes become more integrated, many developers are seeing more and more opportunities to expand their business and better serve their clients by using Access to leverage the functionality in other programs. Fortunately, one of the main features making Access and the entire Office Suite so popular is the increased integration between applications within the Suite itself — not just to share data, but to literally open and manipulate the program with all of the features and benefits of working directly with its user interface.

You've seen how to take advantage of Access's data integration features in Chapter 15. In this chapter, ...