O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required