Exporting multiple tables/queries to XML Access 2010

[InuYasha64]

I'm hoping someone can help me understand why my code is not functioning correctly.

Here is the code:

Public Function XML_OutSendBtn_Click()
'export query to selected XML file
    Dim ExportFileStr As String
    Dim objAddress As AdditionalData
    
    ExportFileStr = "C:\Users\Admin\Desktop\Test"
    Set objAddress = Application.CreateAdditionalData
        
    If Right(ExportFileStr, 4) <> ".xml" Then
        ExportFileStr = ExportFileStr & ".xml"
    End If
    
    Set objAddress = objAddress.Add("EMPADDRESS")
    objAddress.Add ("EMPADDRESS")
    
    Application.ExportXML acExportQuery, "EMPLOYEE", ExportFileStr, , , , , , , objAddress
End Function

What happens is that I had to put the Employee Address query in twice "EMPADDRESS" for it to show up on the output XML file. I don't think that I should have had to resort to that for it to work. I'm calling this in a macro and the macro is being called by a command button on a form. I borrowed this code from another post that was solved last year.

Any suggestions would be appreciated.

[June7]

So it works?
This article has example code that does the same thing, except sets two AdditionalData variables.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[InuYasha64]

June7,
Yes, the code works, but not correctly.
I tried the MS code before I found the one posted on this forum from last year.

The MS code did not work for me.
The specific part that breaks is the "Application.ExportXML" portion. That is why I used the code I have listed in my first post.

Beyond just this part, I am attempting to have MS Access handle generating a Parent-Child node set in the XML output.

Any suggestions?
Here is what the XML output needs to look like:

<Parent>
      <Child1>
          <SomeData></SomeData>
      </Child1>
      <Child2>
          <SomeData></SomeData>
      </Child2>
</Parent>

I can get the Child1 and Child2 outputs from the code in my first post, but I really need it to output the way I have shown here.

[June7]

Seems I've seen this topic before, long time ago. My recollection is the Export method can't do that and testing I just did supports conclusion. Each table is exported sequentially into the xml file. You can join EMPLOYEE and EMPADDRESS into a query and export that query but still don't get the structure you want. I think in the other thread poster was resigned to writing custom code to build a text file, line by line, to get what they wanted.