Solved

problem creating XML file in Access 2013

Posted on 2014-11-27
4
137 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
  • 2
  • 2
4 Comments
 
LVL 62

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: 40469871
0
 

Author Comment

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

Accepted Solution

by:
Fernando Soto earned 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.

770 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