How Do I Build an XML request/response

[AccessGuruCarl]

I'm trying to build an XML request, transmit the data over the web, and then unpack the XML response sent back using VBA or VB

I have the URL address, and a sample(if you can call it that) of the XML code with default values. I'll need to edit these values with variables entered into the form.(Weight, Dest., Origin,ect...)

I need help or a point in the right direction, how to do this in MS Access. Any sample code will be helpful.

Trying to incorporate this in a Phone Orders db, that will retrieve postal rates from USPS. But they offer very little help only the tools(ability) to get the data.

My main question is: Can I do this without a webserver?
From the samples, it looks like all the processing is done on the usps site, then a response is sent back(The postage).

Thanks in advance, for taking the time to help fellow programmers. Any help would be greatly appreciated.
I'm lost! With Error after Error after Error...


AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[kav123]

You could used ServerXMLHttp to get the response back from the webserver. In VBA, if you go to Project/References and set reference to MSXML2.0, and declare an object for ServerXMLHttp

Dim objXML as MSXML2.ServerXMLHttp

This has properties and methods to access a remote webserver and get the response back in Text/XML format and read the contents.

Hope this helps.