Access 2003 VBA Programmer's Reference

D.5. The Parameters Collection

The Command object has a Parameters collection associated with it that contains all of the Parameters objects of the Command object. The actual Parameters collection does not contain any properties.

D.5.1. Methods of the Parameters Collection

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

D.5.2. Properties of the Parameter Object

The following table lists the various properties of the Parameter objects in the Parameter collection.

Property	Data Type	Description
Name	String	Sets or returns the name of the Parameter
Value (default property)	Variant	Sets or returns the value of the Parameter
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
Precision	Byte	Indicates the degree of precision for a Parameter object. This sets or returns a byte field to represent the maximum number of digits used to represent values
NumericScale	Byte	Sets or returns a byte value that indicates ...