Recent content by nuglorious

hi all I wonder if its possible to import .rtf files into access2k. I have search high and low but not avail. Pls advised. Thank you nuglorious

hi there In query, i have 1 column which shows currency and value together like this USD 1000. So I would like to shows value only. I would appreciate anyone could help me solve this problem. :( thank you nuglorious

hi targol Sorry for late reply. It works ok on msgbox now (from your previous post and I used it)and it shows me the nodename. I thought another idea which something as below stated:- Dim intanswer As Integer Set objNodeG_0FirstChild = objNodeLIST_G_0.childNodes(0) Set rst =...

Hi there Thanks for your quote but theres a problem with objNodeItem.nodename that in the msgbox it shown as "#text" which arent it suppose should interpret as according to xml data such as like "VSL_NAME0" and so on?Is there some missing code or whatsoever??Please advise.[pc1] Thank you redgs...

I like your idea and I have follow your steps but my table still blank.[ponder] I have no idea what errors in my code but I need your guidance. Herewith, I paste my code here:- Set objNodeG_0FirstChild = objNodeLIST_G_0.childNodes(0) For Each objNodeG_0 In objNodeG_0FirstChild.childNodes For...

It works alright with msgbox,[thumbsup2] but how to capture the xml data into access table?It suppose to capture all the 29 xml data from <G_0> itself and so on.[ponder] Looking forward hearing from you soon. Thanks n rdgs nuglorious

Hi Targol About my previous post dated 28/6/05, please ignore as I found my error on vbscript. Its my mistake. Ok, the msgbox right now appear but doesnt seems to serve any pupose. Another thing I found out is that theres are 29records of <G_0> which means my access table should have 29 records...

If thats the case, how to recognise what VBscript Im using as Im not sure where to find out?Im apologised for any inconvenience cause. Thank n redgs nuglorious[fish2]

Isit? I see, the code im using is scripting.filesystemobject. So i guess the code its under server side. If thats the case, is there anywhere solutions?? Thanks n redgs nuglorius[3eyes]

Hi Targol Im sorry I couldn't understand what do you mean. Could you please show me how. Thanks n redgs nuglorious

Yes, you are correct. <List_G_1> is contained into <G_0>. I tired your code given but nothing happen. Is there something amiss??? thanks n redgs nuglorious [ponder]

Hi Targo Firstly, Im sorry that my structure that I posted previously were not clear enough. My appologies to you.[mickey]. Im glad that there someone like you knew how and thank you for your coding but the real structure is should be read as follows :- - <BLBLR03A> - <LIST_G_0> - <G_0>-->Set...

hi there firstly, i do not know how to explain it clearly so i attached the xml as follows:- - <BLBLR03A> - <LIST_G_0> - <G_0> ---->Set objNodeG_0 = objNodeLIST_G_0.childNodes(0) <VSL_NAME0>HARI BHUM</VSL_NAME0> <VSL_ABRV0>HARI BHUM</VSL_ABRV0> <VSL_CURR0>HBM2</VSL_CURR0>...

hello there, Besides on this method, I have MS Access2K and i have xml files which i need to import to access itself. Does anyone knows how to go about it as I have tried to import directly but error message. The xml files looks like this as follows (in short) :- <VSL_NAME1>HARI BHUM</VSL_NAME1>...

Hello there since 3days i have an unsolved matter on showing records in unbound textbox. I hv created an unbound txtbox to search tht particular item. Example i would like to view the data and the item is 'haiphong' into the unbound txtbox. and the records should shows 5 records i/o 1 record...