O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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

Using Automation Servers with Access 97

To use Automation, you must first write the code to create an instance in your application of the object that you plan to program. Access VBA contains the following four reserved words that you use to create an instance of a programmable object with Access VBA code:

  • The Object data type is assigned to the programmable object variables you declare with {Private|Dim|Public} objName As Object statements. The Object property of a programmable Automation object contained in a bound or unbound object frame control points to the instance of the object. You can assign to an Object variable a pointer to the Automation object with the general syntax

    								Set objName = [Forms!frmName!]uofName.Object
    
  • The CreateObject function ...

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