Special Edition Using Access 97, Second Edition

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