Recent content by Tea

Is there a different approach where the code would look cleaner? Is there a function that replaces especially these symbols? I would like to apply this to another field also, but it would mean I would have to repeat the same problem. If there was another & in the second string for the field...

I have removed the for each loop, now it works fine. Made kinda sense, when the escape sequence has it's own &.

I have remove the for each altogether, it works now.

As I mentioned in the above reply, I've already tried that.

I don't thnk it's necessary to have Rich text on this field as it's not for HTML purposes. I'm generating an XML through a form. But if a field contains those special characters it does not create the xml tags becuase XML can'T read these symbols without escaping them.

I have tried that, but it's still not working. Has the same result. What do you mean?

Yes I did. The xml parser throws an exception and the xml file is created without the CDATA tags. So it's just a one line string without tags

I'm trying to find a way to replace special characters (<, >, &, ', ") in my description field with the escape sequences, so I can use the newString in a string, that is later on use to generate a xml file. Const SpecialCharacters As String = "<,>,',&" 'modify as needed Dim myString As String...

That's right. I can't seem to find any information regarding this, if it's a part of a MS package or office in that matter.

Does it matter which version of library am I referencing to? What's the difference? Thank you for the infomation.

This would be the early binding if I understand correctly, because I'm declaring a specific object variable. Dim streamObject As ADODB.Stream Set streamObject = New ADODB.Stream With streamObject .Charset = "utf-8" .Mode = adModeReadWrite .Type = adTypeText .Open...

Thank you! I've found my solution through the ADODB.Stream. Is the ADO library on every users computer? What if I want to share my database with someone, that can't change or add library references? Will it still work?

Have never used ADODB.Stream. How would it look like?

That is working. But I have questions: why does UTF-8 not work? Also the format of the generated file is in ANSI Western European 1252, is it possible to convert the file to utf-8 instead? Instead of changing the encoding in the file content? Is it possible to change the encoding in Acess...

Hi all, I have an issue regarding encoding in a XML file. I'm using czech letters like "Č, á, í"... inside a body tag of an XML and the error seems to occur whenever there are letters with acute or circumflex. I'm actually printing some text content into an xml file. Snippet of the code Dim...