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
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.
ws_liststudies.mdb 372 KB