Calling Webservice from Access 2007

I am using Access 2007. I need to call the following webservice at the following URL. The webservice returns a string value. I have a reference to the Microsoft Office Soap Type Library v3.0. I am using the Visual Basic version of the webservice.
---------------------------------------------------------------------------------------------------
NADSWebserviceVersion.TIMECARD_VERSION_1

https://timecardweb.econz.com/axis/services/timecard1Soap?wsdl
---------------------------------------------------------------------------------------------------

Thanks,

Microsoft AccessMicrosoft Development

Last Comment

CloudApps

8/22/2022 - Mon

Nico Bontenbal

3/20/2012

This webservice has many methods. So you need to know what method you want to call. In Office 2003 you had the http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2224 but this is no longer available in 2007. If you have a Office 2003 machine somewhere you could use that to create the code to call the webservice and then convert it to 2007.

Here's some information about calling a webservice from Office 2007:
http://msdn.microsoft.com/en-us/library/dd819156(office.12).aspx#xl2007ConsumingWebServices_ExploreIt

CloudApps

3/20/2012

ASKER

Nicobo:

I have the Microsoft Office Development Tools installed as part of my Visual Studio 2010.

It does not list Access as an option for building an Add-In. It does show Excel, Outlook, Word...

Going back to Office 2003, does not feel like a good option going forward.

Help!

ASKER CERTIFIED SOLUTION

Nico Bontenbal

3/20/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

CloudApps

3/21/2012

ASKER

Nicobo,

I took your advice and used Access 2003 with the Web Service Toolkit to consume the webservice.

It is a great tool.

I guess it is Microsoft that I am upset with for having removed the toolkit from Access 2007.

Thanks again,

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23

Nico Bontenbal

3/22/2012

And this codes works in 2007/2010 as well, doesn't it?

CloudApps

3/22/2012

ASKER

Nicobo,

The class modules create by the Web Service Toolkit compiles and runs in Access 2007. I have not tried it in Access 2010.

The database itself is a .mdb

Thanks again,