Map Issues with Bing and Google

[grahamvb]

Hello Access-Programmers,

I am using the Access 2010 Web Browser Control in an attempt to display driving directions.

I am working with both Bing and Google maps to see which works best. Also, the licensing terms are very different, if I understand the terms correctly, Bing appears more open to free use,
within monthly and annual limits. Google appears to prohibit the free user from printing a map, even with a copyright notice. But I digress.

In the attached database I have a few map issues.
1. When maps display they display the entire web page within the Web Browser Control, not just the map?
2. Bing recognizes that directions are sought but does not pick up the destination address?
3. Google generates a sensor parameter missing error, although the parameter seems to be there?

I tried to follow the instructions for developing map URL's from Bing and Google at:
http://msdn.microsoft.com/en-us/library/dn217138.aspx
https://developers.google.com/maps/documentation/webservices/

The Web Browser Control, Control Source property for Bing is set as:

="http://bing.com/maps/default.aspx?rtp=adr." & [txtBingAddress]

The Web Browser Control, Control Source property for Google is set as:

="https://maps.googleapis.com/maps/api/directions/xml?origin=" & [txtHome] & "destination=" & [StoreAddress] & "+" & [StoreCity] & "+" & 
[StoreState] & "sensor=false"

I am at a loss as to why these issues are cropping up.
Any thoughts, even on one of the above issues would be appreciated?

Thank you in advance for looking into this.

 

[namliam]

Your code for bing doesnt seem to include the destination at all ... Or perhaps it is a pasting error?

It should read something like:

="http://bing.com/maps/default.aspx?rtp=adr." & [txtBingAddress] & "~adr." & [txtDestination]

Which seems to work fine for me

As for google, the URL seems to work for, didnt try to make the API work:

https://maps.google.nl/maps?saddr=StartAddress&daddr=Destination

Hope this helps

 

[grahamvb]

The attached database initially uses the following string for txtBingAddress

1%20North%20Woodland%20Boulevard,%20Deland,%20FL~1699%20North%20Woodland%20Boulevard,%20Deland,%20FL

I see one error in my string, I only used the adr. once before the origin address. when I place it again between the tilde and the destination address I get the from/to search in the map. Thank you. Issue #2 solved.

 

[jdraw]

I posted a sample Google maps and driving distance at
http://www.access-programmers.co.uk/forums/showthread.php?t=225339&highlight=google+maps+driving#5

It may be useful to you.

 

[grahamvb]

namliam, I tried the Google URL you suggested instead of the Google API and it sort of works. (I used .com instead of .nl)

="https://maps.google.com/maps?saddr=" & [txtHome] & "&daddr=" & [StoreAddress] & ", " & [StoreCity] & ", " & [StoreState]

This is the string that is sent to Google maps:

https://maps.google.com/maps?saddr=1401 East New York Avenue, Deland, FL, 32724daddr=125 Jenkins Street, St. Augustine, FL

However an invalid character error occurs. (See attached image).

 

[namliam]

Dont think spaces are allowed in URLs ... are they?
https://maps.google.nl/maps?saddr=Dam,amsterdam&daddr=dam,zaandam

Works just fine...

actually you are missing the & in the daddr which is probably causing trouble as well.

 

[grahamvb]

Bing specifies that spaces be replaced by "%20" but Google does not seem to be so specific. What should replace the spaces?

(Answered through research "+")

 

[grahamvb]

What I end up with is:

="https://maps.google.com/maps?saddr=" & [txtGoogleAddress]

txtGoogleAddress =

900+East+New+York+Avenue,+Deland,+FL,+32724&daddr125+Jenkins+Street,+St.+Augustine,+FL

This results in the attached error and the Web Browser Control goes blank if I choose either Yes or No in the Script Error message box.

 

[David R]

should be ...

&daddr[COLOR="Red"][SIZE="6"]=[/SIZE][/COLOR]125...

 

[grahamvb]

This generates the same error and blank control.

https://maps.google.com/maps?saddr=900+East+New+York+Avenue,+Deland,+FL,+32724&daddr=125+Jenkins+Street,+St+Augustine,+FL

 

[namliam]

The last link you gave Graham seems to work for me