By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

Web Services Under MS Access 2003?

P: n/a
I've got the Office XP Web Services Toolkit installed, but it doesn't do
"Complex" data types - which seems tb my real world.

I can make this work ("Simple") data types:
-------------------------------------------------
Sub xx()
Dim mySC As SoapClient
Dim myIndustryName As String

Const mySampleSicCode As String = "100"

DoCmd.Hourglass True

Set mySC = New SoapClient
mySC.mssoapinit "http://ws.invesbot.com/companysearch.asmx?WSDL"

myIndustryName = mySC.GetIndustryName(mySampleSicCode)
MsgBox myIndustryName
Set mySC = Nothing

DoCmd.Hourglass False
End Sub
-------------------------------------------------

But I'm still groping when it comes to "Complex".

On the input side, I'm guessing that I have to concoct the proper XML to convey
the required parms and then feed it to whatever method I'm invoking as a string
just like the "Simple" example above.

For the output, my guess is that I have to set a ref to "Microsoft XML, v3.0"
(Library MSXML2, C:\WINNT\System32\msxml3.dll) and write code to iterate through
the XML string that's returned.

Have I got it right so far? If so, can anybody steer me to a concrete example
written in VBA? All the examples I've come across so far are written from an
HTML perspective and I'm having trouble figuring out what's needed (headers and
so-forth) and what is not on the input side.
--
PeteCresswell
May 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.