[AccessD] XML

marty
 
The full file is below. Would it be just as easy to create this totally in an editor or via VBA.  The XML file itself isnt a problem. If you notice the values for example maxReplies set to 25. If I was doing it I would just type it up and then pass the string to VBA. What do you think?
 
<mapping>

<formProperties>

<automateDataCollection>true</automateDataCollection>

<enableDataCollection>true</enableDataCollection>

<maxReplies>25</maxReplies>

<numReplies>0</numReplies>

<allowMultipleReplies>true</allowMultipleReplies>

<allowMultipleRows>true</allowMultipleRows>

<onlyUpdates>false</onlyUpdates>

<stopDateTime>0</stopDateTime>

<onlySentTo>true</onlySentTo>

</formProperties>

<tables>

<table name="table1" accessTable="Customers" collectionType="insert">

<iterate root="/AccessInfoPathForm/dcip:inlinedata/dcip:row">

<mapitem IsPrimaryKey="1" formNode="dcip:PrimaryKey" tableCell="ID"/>

<mapitem formNode="table1:field1" tableCell="Company" caption="Company" readOnly="false" required="false" type="x:string"/>

<mapitem formNode="table1:field2" tableCell="Last Name" caption="Last Name" readOnly="false" required="false" type="x:string"/>

<mapitem formNode="table1:field3" tableCell="First Name" caption="First Name" readOnly="false" required="false" type="x:string"/>

</iterate>

</table>

</tables>

</mapping>

 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477