google maps script error and control problem

[angie]

Google Maps Angies.zip
I have a Script Problem when I click on the Google Map button, also I would like to have control over the map so that I could reposition or zoom in or out. Thanks everyone. Angie
I have attached a sample of my program the basic when you open it will go to the schedule and if you click show all calls and than the google map button it will open another form which you will click on google map and then you will see the script error and see the addressed plotted but can not zoom in or out no map control.

[ItsMe]

Can you post some of the code and indicate the line of code that is throwing the error?

[angie]

Script error
line 780
char 172
error invalid character error
code o
url. Http://maps.google.com/mapfiles/home3.html

is this what you wanted.

[ItsMe]

What I am asking is for you to do the legwork and post the VBA that you believe is causing the issue.

[angie]

Private Sub GoogleMaps_Click()
DoCmd.Hourglass (True)
MyGoogleMapURL = "http://maps.google.com/maps?q=from: "

MyGoogleMapURL = MyGoogleMapURL & Me.[ClientPickupList].Column(0, Goog1)
For Goog1 = 1 To Me.[ClientPickupList].ListCount - 1
MyGoogleMapURL = MyGoogleMapURL & " to: " & Me.[ClientPickupList].Column(0, Goog1)
Next
MyGoogleMapURL = MyGoogleMapURL & "&iwloc=A&hl=en"
DoCmd.OpenForm "frmGoogleMap", acNormal
Forms![frmGoogleMap].wbbWebsite.Navigate URL:=MyGoogleMapURL
'http://maps.google.com/maps?q=from:++LS20+8AS+to:+LS20+8AS++&hl=en&ie=
'UTF8&ll=53.87023,-1.713985&spn=0.003688,0.011319&z=17&pw=2
DoCmd.Hourglass (False)
End Sub

[June7]

And which line in the posted code is 780? And which character is 172?

However, I did download your db and test the code. The Google Map window opens and I am able to move it and zoom. It says
We could not find from: 5933 CASTLE DR MILTON FL 32570 to: 5907 ...

I also got message:
It looks like you have enabled Internet Explorer Compatbility View. Google Maps will not work correctly unless this is turned off.

Then I Exit the window and try again. The window looks different and now cannot zoom. Reopening db does not get me the original behavior.

Weird.

Also getting error when mouse over the up/down arrow buttons.

[angie]

Hi June7, I don't know. If you open the zip file I attached you can try and see what I am trying to say. When you click on google maps it will open the map but gives error you can click yes it goes away and the map is there with the locations I can't figure out what is causing it. I would use bing maps but could not get it to work only wanted to route from one address to the second would not let me see all locations. I don't need driving directions just locations with tags.

[June7]

I did open and try. That's what my previous post was about.
I edited my previous post with more comments.