XML Stored in a memo field.

[Rodders05]

I have a string of XML stored in a memo field. I need Access to recognise it is xml so when it is clicked it launches internet explorer and displays it to a user. I can't change the field type as I'm linking tables to a Sybase database.

Also does anyone know how I can get my form to continue to poll for new data so the users see real time information through my link table without having large impacts on performance.

I'm desperate so any help is very much appreciated.

Thanks

[NeoPa]

Not an area I'm too familiar with, I'm afraid.
I would expect, for the IE link to work, you'd need an OLE field but, as you said, because it's linked into a Sybase back-end, this is not possible. I don't believe, in that case, that there is a solution.

[Andrew Thackray]

Try this in the click event on the memo field

[code]

if left(memofield,5) = "<?xml" then

Shell "IEXPLORE.EXE"

[PEB]

Yeah,

I agree with this part with Andrew but firstly you need to save your XML from Memo to a file! And then open the link to this file using followhyperlink sub...

To save your memo as a file use the following...

Function save_file(My_XML)
Open "C:\Temp.xml" for output AS #1
Print #1,My_XML
Close #1
Application.FollowHyperlink "C:\Temp.xml", "", True, True, , , "My system information"
End function