Access 2003 Web Service NEWBIE MSXML2.IXMLDOMNodeList ????

T

tapper_rx

I am attempting to use Access 2003 (with the 2.0 services toolkit
installed) to pull data from, and after compare/append push data back.

So far I seem to be having luck pushing data to the service, but for
the life of me, I am lost on how to pull the information. I suspect
that it is some form of complex data, as the return seems to be defined
as XML, and toolkit that created the class module identitifed it with
an "any" prefix.

The function I am trying to get going is as follows.

Public Function wsm_GetAllOfficers(ByVal str_email As String, ByVal
str_pwd As String, ByRef any_dsData As MSXML2.IXMLDOMNodeList) As
Boolean
'*****************************************************************
'Proxy function created from
https://www.sleeptime.us/InterfaceServices.asmx?wsdl.
'
'"any_dsData" is defined as XML. See Complex Types: XML Variables
in
'Microsoft Office 2003 Web Services Toolkit Help for details on
implementing XML variables.
'*****************************************************************

'Error Trap
On Error GoTo wsm_GetAllOfficersTrap

wsm_GetAllOfficers = sc_InterfaceServices.GetAllOfficers(str_email,
str_pwd, any_dsData)

Exit Function
wsm_GetAllOfficersTrap:
InterfaceServicesErrorHandler "wsm_GetAllOfficers"
End Function


Is there any help out there to be had? I am totally green when it
comes to web services, and this project needs to get going

Many Thanks

T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top