Class AdditionalData (Access VBA)

The class AdditionalData represents the collection of tables and queries that will be included with the parent table that is exported by the ExportXML method. To use a AdditionalData class variable it first needs to be instantiated, for example

Add

Adds an add table or query that will be included when the ExportXML method is called.

Add (var)

var: The name of the table or query to add.

Dim strvar As String: strvar = 
Dim ada As AdditionalData
Set ada = CreateAdditionalData.Add(var:=strvar)

Count

You can use the Count property to determine the number of items in a specified collection.

CreateAdditionalData.Count

Item

The Item property returns a specific member of a collection either by position or by index.

If the value provided for the index argument doesn't match any existing member of the collection, an error occurs. The Item property is the default member of a collection, so you don't have to specify it explicitly. For example, the following two lines of code are equivalent:

Item (Index)

Index: An expression that specifies the position of a member of the collection referred to by the expression argument. If a numeric expression, the index argument must be a number from 0 to the value of the collection's Count property minus 1. If a string expression, the index argument must be the name of a member of the collection.

Name

You can use the Name property to specify or determine the string expression that identifies the name of an object.

A valid name must conform to the standard naming conventions for Microsoft Access. For Access objects, the name may be up to 64 characters long. For controls, the name may be as long as 255 characters. The default name for new objects is the object name plus a unique integer. For example, the first new form is Form1, the second new form is Form2, and so on. A form can't have the same name as another system object, such as the Screen object. For an unbound control, the default name is the type of control plus a unique integer. For example, if the first control that you add to a form is a text box, its Name property setting is Text1. For a bound control, the default name is the name of the field in the underlying source of data. If you create a control by dragging a field from the field list, the field's FieldName property setting is copied to the control's Name property box. You can't use "Form" or "Report" to name a control or section. Controls on the same form, report, or data access page can't have the same name, but controls on different forms, reports, or data access pages can have the same name. A control and a section on the same form can't share the same name.

CreateAdditionalData.Name =