Share via

  • Article

Add (CustomProperties Collection)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Add method of a CustomProperties collection creates a new Property object, adds it to the collection, and returns a reference to the object. This method applies only to CustomProperties collections.

Syntax

Set vRet = object.Add(ByVal Value, [ByVal Name As String], [ByVal DataType As VBA.VbVarType)

Remarks

  • vRet
    A Variant variable that receives the instance of the new Property object. Instead of a variant, you can use a variable that has been declared as type DSO.Property to match the object being retrieved from the collection.

  • object
    An instance of a CustomProperties collection.

  • Value
    A Variant that contains the value of the Property object.

  • Name
    (Optional) A string that specifies the name of the Property object.

  • DataType
    (Optional) The data type of the property. A Microsoft® Visual Basic® data type defined in the VBA.VbVarType enumeration.