I have a trial user name and password from the UK's Companies House XML gateway.
I would like the VBA code to be able for a button to be pressed on an Access 2003 form to query the Companies House XML Gateway by a specified Company Number, and retrieve the basic Company Information, such as name, address etc.
The information can be displayed in a Msgbox for this projects prupose. Though you can display on the form if you wish.
Ideally the code should be supplied complete with the database, form and button