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.3. Properties Collection and Property Object

The Properties collection contains all of the Property objects for a specific instance of any given object. The previous statement may be somewhat confusing, but what it really means is that every object contains properties. All of those properties are stored in a Properties collection for that particular object. The Properties collection for the Error object contains the Description, Number, Source, SQLState, and NativeError properties. There are two types of properties: dynamic and built-in. Neither type of property can be deleted.

E.3.1. Properties of the Property Object

Every Property object has four properties of its own, which are detailed in the following table.

PropertyDataTypeDescription
AttributesLongLong value that indicates characteristics of the property that are provider specific.
NameStringString that identifies the property.
TypeIntegerInteger that specifies the property data type.
ValueVariantThe default property value. A variant that contains the property setting.

No methods are associated with the Property object.

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