Question about building up XML codes inside Acces.

[Mitchy]

Hey there I am rather new to working with Microsoft Acces and I have now come to the point that I want to integrate certain data into a static 'dummy XML code' which will ultimately end up in Acces building up the full .xml code.

I have first focused on splitting and re-calculating the data so the optional variables for the XML code are clearly splitted and noted in such way that it's readable. This is now done, next point to integrate it into XML.

But after trying to set the standard value of a field as a part of the needed xml code with the variable noted as for example 'A'. It keeps giving me an error message , I also tried to set a Replace function which should search for empty fields and replace them with the 'dummy xml code'.

I plan to note it as following;
NAME (variable) ||| NAME CODE
A ______|||_____<name>Name (variable)</name>

Then as next step to let it overwrite Name (variable) into the Name code field.

1. I am unable to update the Name code into the xml dummy, setting it as standard value wont work, probably has something to do with the <>/ characters but getting it into this field is essential else there is no point continuing this .

I hope someone can help me out, I personally believe that the <>/ are the problem but I could be totally wrong! Thanks in advantage and take care

 

[namliam]

?replace("<name>Name (variable)</name>", "Name (variable)", "Your Mailmain")
<name>Your Mailmain</name>

It seems to work just fine?

 

[Mitchy]

?replace("<name>Name (variable)</name>", "Name (variable)", "Your Mailmain")
<name>Your Mailmain</name>

It seems to work just fine?

well the replacing at the end will not be a problem, but that step is one step too far . My question is how to set the standard value, or the value of the column 'NAME CODE' as <name>Name (variable)</name>
As the size of the whole DB/ nr of lines are flexible it has to put the dummy file into it EVERY SINGLE LINE. I am having problems with getting that done. It seems like it wont allow me to put in <name>Name (variable)</name> as a standard value, or it wont let me replace blank fields with it.

 

[namliam]

<Rant>
I dislike, hate, lothe, dispise, pationatly truelly heart felt deeply HATE XML file.
On averege it is a fancy looking 'buzzed up' variation of a simple CSV.
</Rant>

I like being in full control, the way I ussually make xml is by hardcoding it in VBA.