We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

A starting point for web services with VBA

Hi all,
I've been playing around with MS Access/VBA as a client for web services
and I would like to share what I found in the attached zip.
It's an extremely simple example, but it has some useful features.
To use it, open table tblSOAPParameters and edit the record which has as
SOAPparameter "sysURL" to match URL and port of your webservice.
Then open the (only) form frmGetStudies and type in your name and password
and secretly these will be sent to me ;-) and then click the button.
The studies in your OC-instance will be written in tblOCStudies.
Enjoy,
Gerben Rienk
http://www.trialdatasolutions.com
Attachments:
ws_liststudies.mdb 372 KB

Comments

  • Hi Gerben,
    Excellent idea. I could not get to the MDB file , though, as it was stripped
    of by my mail system as a security risk. Can you ZIP it up instead.
    Regards
    Krister
    -----Original Message-----
    On Behalf Of Gerben Rienk Visser
    Sent: 20 September 2011 11:38
    To: [email protected]
    Subject: [Users] A starting point for web services with VBA
    Hi all,
    I've been playing around with MS Access/VBA as a client for web services and
    I would like to share what I found in the attached zip.
    It's an extremely simple example, but it has some useful features.
    To use it, open table tblSOAPParameters and edit the record which has as
    SOAPparameter "sysURL" to match URL and port of your webservice.
    Then open the (only) form frmGetStudies and type in your name and password
    and secretly these will be sent to me ;-) and then click the button.
    The studies in your OC-instance will be written in tblOCStudies.
    Enjoy,
    Gerben Rienk
    http://www.trialdatasolutions.com
This discussion has been closed.