Recent content by hinke

Solved it! I did not realize you had to add Table3 to Table2 as a relationship. I thought Access could figure it out. Anyway, here's the code if anyone wants to know how to do it. Dim objInfo As AdditionalData Set objInfo = Application.CreateAdditionalData With objInfo .Add...

objOtherTbls.Add "Orders" objOtherTbls.Add "Order Details" DataSource:="Customers" Replace the text inside the quotes and put your table names there. Create a button on a form and create an On Click Event for the button. Place the code there.

Hi, I have been hitting my head against the wall the last few days because I can't get the export of access tables to XML to work. I have 3 tables total. Table1 is the main table and can have many records of Table2. Table2 can have many records of Table3. When I export via...