A few years ago I worked with members of this group and Stack Overflow to develop a callable module that sent a data string to the Google Maps API and received back simple travel time and distance information. (Thank you all for your assistance!)
The data string contained Access table information; starting street address, starting city, starting state (followed by) ending street address, ending city, ending state. There was an Access form that displayed the location table and simply allowed the user to number 1-x the locations to be visited then called the module with each starting and ending string along the route, finally displaying a table with the travel time and mileage.
I am attaching the relatively simple module that worked so reliably for years and now returns nothing.
It appears that Google recently monetized their maps API service. They have a free tier that would be ok but their sign up process does not work for me. So I am examining Bing and Here map API's. I have managed to obtain free API keys from both Bing and Here (which I was unable to get at Google), and am beginning the arduous process of creating a new callable module for those services. I am experiencing the following initial issues:
Does anybody have information regarding existing VBA that can be (or better yet (already has been)) adopted to the newer API's?
Does anybody have any suggestions for a quick and simple solution to the dilemma?
Could not tag "Here" for this post as too common a word.
The data string contained Access table information; starting street address, starting city, starting state (followed by) ending street address, ending city, ending state. There was an Access form that displayed the location table and simply allowed the user to number 1-x the locations to be visited then called the module with each starting and ending string along the route, finally displaying a table with the travel time and mileage.
I am attaching the relatively simple module that worked so reliably for years and now returns nothing.
It appears that Google recently monetized their maps API service. They have a free tier that would be ok but their sign up process does not work for me. So I am examining Bing and Here map API's. I have managed to obtain free API keys from both Bing and Here (which I was unable to get at Google), and am beginning the arduous process of creating a new callable module for those services. I am experiencing the following initial issues:
- All the API's seem to be designed only for modern programming formats (C#, json, xml, etc.) ignoring Access VBA.
- The API's appear to require GPS coordinates. All my data is in the old fashioned mail address format.
Does anybody have information regarding existing VBA that can be (or better yet (already has been)) adopted to the newer API's?
Does anybody have any suggestions for a quick and simple solution to the dilemma?
Could not tag "Here" for this post as too common a word.