Topics Search

Google Maps

Google Maps
Views: 121
I have a DB for our Church Hamper Service and I need to be able to check addresses using Google maps or something similar, I have searched the Forum but can't find what I need. Using MS Access 2010

I want to be able to lookup the addresses of a client but find a route, we just need to confirm the address as we are a fixed point i.e. everything is sent from us.

Also want to keep as simple as possible as some of the volunteers are not computer literate.

The DB will be used by up to 8 people per month and I have checks in place to stop any deletions etc
Sponsored Links:

More topics

 

google maps hyperlink for access

Preview
I am attempting to create a formula with the data setup in the field below to view in Google maps. I have thousands of addresses that I need to reference with google maps.

A B C D E
Downing Street 107 Buffalo New York
Cell A Downing (Street Name)
Cell B Street (Street Type)
Cell C 107 (Address Number)
Cell D Buffalo (City)
Cell E New York (State)
 

Hyperlinking is for the birds :)

Preview
I have been using hyperlinks like this

="http://www.google.com/search?q=" & [FIRST NAME] & " " & [BUSINESS NAME] & " " & [CITY] & " " & [STATE]

However, I have realized this is not my best method. With some of my detailed searches I run into the problem that the url does not display the fields.

Example:
If I open google maps and try a search for "Texas" the url remains http://maps.google.com/ instead http://maps.google.com/q=Texas of I believe this is called a static page.

How can I learn how to command Access to input fields into a search box and press enter. I know it doesn't actually do all of that, but you get the point.

I have tried using the search feature and google, but I don't even know the technical terms
 

Extracting and Combining data from different Fields

Preview
In Field1 I have a Web Browser Control link:
http://maps.google.co.za/maps?q=-25.396769, 27.111767&num=1&vpsrc=0&t=k&z=15&output=embed

In Field2 I have a GPS co-ordinate:
-24.396769, 26.111767

In Field3 I want to combine the link in Field1 and the data in Field2 replacing co-ordinates in BOLD.

In other words the data in Field3 should look like this:
http://maps.google.co.za/maps?q=-24.396769, 26.111767&num=1&vpsrc=0&t=k&z=15&output=embed
 

15 tabbed subforms / google maps Access 2007

Preview
I am modifying an Access 2007 database "Transport company".this database built by someone else, there is a Truck schedule form with 15 tabs, corresponding to 15 trucks. I have imported a google maps module, so when I click on the command button "Map" it takes the address of the customer selected and inputs these values into the google map form, up comes the map.

However, this works fine for the subform selected, but, I need to pass the information independently to the form from all 15 subforms, right now it is tied to the "1st" subform, keeps these values when bringing the map up
 

Macro or formula for google map hyperlink

Preview
I am attempting to create a formula (macro) with the data setup in the fields below to view in Google maps. I wrote a simple one that works in excel, but will not copy to access. I have thousands of addresses that I need to reference with google map. I would appreciate any help to get me through this project. Thanks in advance. Tom

Cell A Downing (Street Name)
Cell B Street (Street Type)
Cell C 107 (Address Number)
Cell D Buffalo (City)
Cell E New York (State)
 

embedded image from Web

Preview
I'm trying to create a report that would use a static map image from Google Maps on each page of the report. I use some GPS coordinates from the database to help generate a URL to show the image from Google in a Web Browser ActiveX control.

Is there a way I can use this ActiveX control on a Report? It works fine in a form.

Or any other solutions to this?
 

Access Google Maps?

Preview
I have this database. how can I create more adresses in the form. to display 100 adresses
 

How to plot entire column's data not just first record.

Preview
I have to following code which works well for the first record in subform "By_Date_To_Award_Form" column "meetloc".

strSearch = Me!By_Date_To_Award_Form.Form.meetloc
Application.FollowHyperlink "http://maps.google.com/maps?f=q&hl=en&geocode=&q=" & strSearch & "&ie=UTF8&z=16&iwloc=addr"

How do I get it to plot all the records in the column "meetloc"? There may be up to 10 records
 

Using Google Earth in Access

Preview
I would like to enter GPS coordinates into a form / table and by pushing a command button, open a screen that displays a google map or opens google earth at that coordinate. Can someone
 

Microsoft web browser ole class object : form vs report

Preview
What the difference is between 'microsoft web browser' ole class object embedded in a microsoft access form and 'microsoft web browser' ole class object embedded in a report.

this code works fine :

Private Sub Form_Open(Cancel As Integer)
gmap.Navigate URL:="http://maps.google.com/staticmap?center=" & latitude & "," & longitude & "&zoom=14&size=512x512"
End Sub

this one does not at all :

Private Sub Report_Activate()
gmap.Navigate URL:="http://maps.google.com/staticmap?center=" & latitude & "," & longitude & "&zoom=14&size=512x