Creates a new schema parameter. Returns a SchemaParameter object.
Syntax
expression.Add(Name, DataType, Size, Scale, Precision, Direction)
expression An expression that returns a SchemaParameters object.
Name Required String. Specifies the name of the new schema parameter.
DataType Optional Variant. Specifies the data type of the new schema parameter. Can be one of the ADO DataTypeEnum constants.
Size Optional Variant. Specifies the maximum length of the new schema parameter.
Scale Optional Variant. Specifies the maximum number of digits to the right of the decimal point.
Precision Optional Variant. Specifies the maximum number of digits used for the parameter.
Direction Optional Variant. Specifies whether the parameter is an input parameter, an output parameter, both an input and output parameter, or a procedure return value. As only input parameters are supported, you should not specify this argument.
Remarks
In design mode in Microsoft Access, the SchemaParameters collection is automatically filled with the available schema parameters.