RUNNING OTHER APPLICATIONS FROM ACCESS WITH AUTOMATION

The number of applications you can drive from Access grows with every version of Access. You can automate all Office 2000 applications, including Access itself.

Driving Word from Access

When using Word or any other application that has a set reference to it, you can receive help while programming for that application, even while in Access. You just have to make sure that you've included VBA Help for that application when you installed Office 2000.

An Access-to-Word Automation Example

This first example for automating Word from Access is fairly straightforward. It performs these functions:

  1. The routine opens a new document in Word.

  2. The routine maximizes Word.

  3. It inserts some text into the document. ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.