2.2.3.24 CT_ForEachRecord

Target namespace: http://schemas.microsoft.com/office/accessservices/2009/11/application

Referenced by: CT_DataMacroStatements

Specifies a set of commands that are performed for each record in a specified set of records.

MUST NOT be present in a CT_DataMacroStatements element that is a child of a CT_CreateRecord or CT_EditRecord element. MUST NOT be present in a CT_DataMacroStatements element that is a child of a CT_DataMacro element whose Event attribute is set to "BeforeChange" or "BeforeDelete".

Child Elements:

Data : A CT_ForEachRecordData element that specifies the set of records on which to perform the commands.

Statements : A CT_DataMacroStatements element that specifies a set of commands to perform on each record.

Attributes:

Collapsed : An Ignored Value.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_ForEachRecord">
   <xsd:sequence>
     <xsd:element name="Data" wbld:cname="Data" type="CT_ForEachRecordData"/>
     <xsd:element name="Statements" type="CT_DataMacroStatements" wbld:cname="Statements"/>
   </xsd:sequence>
   <xsd:attribute name="Collapsed" type="xsd:boolean" wbld:cname="Collapsed" use="optional"/>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).