O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

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

E.5. Parameters Collection

The Command object has a Parameters collection associated with it that contains all of the Parameter objects of the Command object. The actual Parameters collection does not contain any properties or collections, only methods.

E.5.1. Methods of the Parameters Collection

There are exactly three methods for the Parameters collection. They are described in the following table.

MethodArgumentsDescription
AppendParameter objectUsed to add a Parameter object to the collection.
RefreshNoneUpdates all of the Parameter objects in the collection with the latest information from the provider.
DeleteIndexDeletes a Parameter object from the collection. The Index value is either the name or ordinal position of the Parameter in the collection.

E.5.2. Properties of the Parameter Object

Each Parameter object in the Parameters collection contains the actual data for the parameter. The following table describes the various properties of the Parameter objects.

PropertyDataTypeDescription
AttributesLongA read/write property that is the sum of any one or more ParameterAttributesEnum values. The default value is adParamSigned.
DirectionParameterDirectionEnumIndicates if the Parameter represents an input parameter, an output parameter, an input and an output parameter, or if the parameter is the return value from a stored procedure.
NameStringSets or returns the name of the Parameter.
NumericScaleByteSets or returns a byte value that indicates the number of decimal places to which ...

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