I do not consider myself a programmer. Far from it. I do consider myself to be extremely computer savvy. I am a minister who has a contact database in access. I built my database based on a template provided by Microsoft. There is a form that has a button where it will take one to mapquest and map out the location. That's cute but I want something better.
1. Firstly, I prefer the module to use Google maps rather than Mapquest.
2. Secondly, I would like to have a field in the form that calculates the distance between the contacts residence and a fixed location, viz the church. In the field, it should read "________ miles from the church."
3. The button that already exists, when pressed, should create a map of how to get to that location from the fixed location (the church), using Google Maps of course.
This would help me create a route for when I have multiple people to visit; instead of going from one side of town to another. Which, honestly, I do not fall into this trap since I do all this outside of Google. Yet, it takes me a long time to organize my route.
If someone wants to be even more generous, I would like to create a report with filters by zip code where it generates the Google Maps directions in a sheet with the mapped out directions in street view. Basically generate the same thing as when one clicks on "print" hyperlink in google and selects street view.
It would be awesome if someone can provide the code for this module. Thank you so much in advance.
1. Firstly, I prefer the module to use Google maps rather than Mapquest.
2. Secondly, I would like to have a field in the form that calculates the distance between the contacts residence and a fixed location, viz the church. In the field, it should read "________ miles from the church."
3. The button that already exists, when pressed, should create a map of how to get to that location from the fixed location (the church), using Google Maps of course.
This would help me create a route for when I have multiple people to visit; instead of going from one side of town to another. Which, honestly, I do not fall into this trap since I do all this outside of Google. Yet, it takes me a long time to organize my route.
If someone wants to be even more generous, I would like to create a report with filters by zip code where it generates the Google Maps directions in a sheet with the mapped out directions in street view. Basically generate the same thing as when one clicks on "print" hyperlink in google and selects street view.
It would be awesome if someone can provide the code for this module. Thank you so much in advance.
