<div>
<div class="content wysiwyg-content">
I have to interface with a government site from an Access application and there are no API's for <u>VBA</u>. I'm wondering if anyone else has used these tools?<br />
<br />
<a href="https://dev.socrata.com/consumers/getting-started.html" rel="ugc">Here is a link to what I'm talking about...</a><br />
<br />
My being able to do this will be a deciding factor in my getting this project.<br />
<br />
Any help would be greatly appreciated.
</div>
</div>


I have to interface with a government site from an Access application and there are no API's for VBA. I'm wondering if anyone else has used these tools?

Here is a link to what I'm talking about... (https://dev.socrata.com/consumers/getting-started.html)

My being able to do this will be a deciding factor in my getting this project.

Any help would be greatly appreciated.

Socrata SOAP Open Data - API or SDK for use with VBA

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Simple Object Access Protocol (SOAP) is a protocol specification for exchanging structured information in the implementation of web services. It uses the XML Information Set for its message format and uses other protocols, notably Hypertext Transfer Protocol (HTTP) and the Simple Mail Transfer Protocol (SMTP) for message transmission.