Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Beginning Access 2003 VBA
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Access 2003 VBA
This is the forum to discuss the Wrox book Beginning Access 2003 VBA by Denise M. Gosnell; ISBN: 9780764556593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access 2003 VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 30th, 2004, 02:18 AM
Registered User
Join Date: Dec 2004
Location: Middleton, WI, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Terra Server Web service problem

Hi, it's me again!

Just working through chapter 7. Trying the consuming of a web service example using Terra Server Web Service and it doesn't work for me. When I try to run the TestWebService routine I get a compile error in the struct_TileId structure on the "Public Scale as String" line.

Error reads:
Compile Error:
Expected: Identifier

and it highlights the word "Scale".

Has anyone else run into this problem or was able to get it to run? Any suggestions how to fix it? I am running Access 2002 sp3, I hope that doesn't make a difference.

Thanks in advance,

Reply With Quote
  #2 (permalink)  
Old March 14th, 2005, 09:29 PM
Authorized User
Join Date: Dec 2004
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts

I'm also getting an error when attempting to consume the Terra Server web service. However, I'm not getting the same error as mentioned in the original post. Instead, I'm getting a "Type mismatch" error on this line:

strResult = ts.wsm_ConvertLonLatPtToNearestPlace(objLonLatPt)

I tried defining strResult as Variant, but that didn't fix the problem either.

I have Access 2003 installed with Jet 4.0 SP8. The code I'm running is the downloaded Ch7CodeExamples.mdb code, except that I went through the steps described on pages 205-207 to set a reference to the service. Has anyone been able to get this to work?

Reply With Quote
  #3 (permalink)  
Old October 10th, 2005, 11:37 PM
Registered User
Join Date: Oct 2005
Location: Garden Grove, Ca, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

I'm getting the same error. At first I thaught it wasn't working because I have XP and a few things haven't work because, but if you folks are having the same problem, maybe it's the service.

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Service Server Requirements ashokparchuri .NET Web Services 0 January 2nd, 2007 06:26 PM
can not connect to the web-service remote server? okll .NET Web Services 4 May 24th, 2006 06:08 PM
Web Service Vs. Client/Server gabrielboys .NET Web Services 10 January 10th, 2006 06:48 AM
ATL Server Web service keepac .NET Web Services 0 April 15th, 2004 05:30 PM
SQL server 2000 as a web service lachupacabra .NET Web Services 0 November 17th, 2003 04:45 PM

All times are GMT -4. The time now is 03:19 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.