?
Solved

problem creating XML file in Access 2013

Posted on 2014-11-27
4
Medium Priority
?
145 Views
Last Modified: 2014-12-01
this is what I get<infoTable xmlns="">
The requirement is that there be no name space tags on any elements.
code.txt
test2.inftab.xml
0
Comment
Question by:durick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40469293
Hi durick;

If you do not want any namespace in the document then try removing these lines from your code.

'eleInformationTable.setAttribute "xsi:schemaLocation", "http://www.sec.gov/edgar/document/thirteenf/informationtable eis_13FDocument.xsd"
eleInformationTable.setAttribute "xmlns", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
'eleInformationTable.setAttribute "xmlns:n1", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
eleInformationTable.setAttribute "xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"

Open in new window

0
 

Author Comment

by:durick
ID: 40469872
does not explain the - <infoTable xmlns=""> entries
0
 
LVL 63

Accepted Solution

by:
Fernando Soto earned 1500 total points
ID: 40471592
The question states, "The requirement is that there be no name space tags on any elements.", but yet the root node does have a namespace associated with it.

From your last post, "does not explain the - <infoTable xmlns=""> entries", this statement from your code,

eleInfoTable = docDocument.CreateElement("infoTable")

which uses a single string as a parameter does not insert a namespace into the node. I would look at your code again and make sure you are not using the one with two string parameters of which the second one would be the namespace.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question