Access™ 2007 VBA Programmer's Reference

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.

Method	Arguments	Description
Append	Parameter object	Used to add a Parameter object to the collection.
Refresh	None	Updates all of the Parameter objects in the collection with the latest information from the provider.
Delete	Index	Deletes 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.

Property	DataType	Description
Attributes	Long	A read/write property that is the sum of any one or more ParameterAttributesEnum values. The default value is adParamSigned.
Direction	ParameterDirectionEnum	Indicates 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.
Name	String	Sets or returns the name of the Parameter.
NumericScale	Byte	Sets or returns a byte value that indicates the number of decimal places to which ...