[AccessD] Access and Google maps

[David Emerson]

Hi Listers,

I have one item left to confirm but am having trouble finding out if it is possible.

Once I have positioned my markers on the Google map within the Access web control I would like to be able to trap the Click event of a marker, pass the details of what marker was clicked to Access so that I can open up an Access screen with the specifications of the underlying asset.

Does anyone have any code or links to a website where I can confirm that this is even possible?  I can't find anything on the https://developers.google.com/maps site.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand


-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of David Emerson
Sent: Saturday, 11 September 2021 1:09 pm
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

Further information.  The client is wanting a stand alone system that can be used by Telcos from the smallest to the largest.  Not all of them will have the resources to purchase other systems if they are needed.  He is also only wanting limited GIS capability (get the map from Google, plot the assets from the database, show the underlying specifications of the assets from the database data when an asset is clicked on).

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of David Emerson
Sent: Saturday, 11 September 2021 11:11 am
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: 'James Button' <jamesbutton at blueyonder.co.uk>
Subject: Re: [AccessD] Access and Google maps

Good suggestion Jim,  I will follow this one up.

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of James Button via AccessD
Sent: Saturday, 11 September 2021 11:06 am
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: James Button <jamesbutton at blueyonder.co.uk>
Subject: Re: [AccessD] Access and Google maps

Maybe worth the effort of a chat to the local street and property control and authorisation authority - in the UK that would be the "local Government Authority"
They will be dealing with requests for installations of lighting and utility facilities - access points etc and have high resolution maps of their areas, that would include wiring ducts drainage and utility supply, and have to deal with things like the positioning of water supply stopcock access points, hydrants, 

So maybe there is an app they use that would be appropriate, and at a reasonable cost as it would already exist.

JimB


-----Original Message-----
From: AccessD <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: Friday, September 10, 2021 11:32 PM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

I'm also wondering (into the bourbon) why a client would be willing to pay so much to customize such an odd request when there's probably something cheap already out there. 

I also took care of my great grandbaby while their parents took a quick vacation. 

I'm .... numb. 😊 

Susan H. 


I am probably not understanding the requirements here, but isn't this what GIS systems are made for?

Doug

-----Original Message-----
From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On Behalf Of David Emerson
Sent: Friday, September 10, 2021 2:25 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

Thanks for the suggestion Susan.

According to the Microsoft site "Map charts can only plot high-level geographic details, so latitude/longitude, and street address mapping isn’t supported."  We need street mapping to plot networks along streets.

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: Saturday, 11 September 2021 12:58 am
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

I know you're asking for Access, but could you possible export to Excel and use the new Geography data type -- it's simple to implement. 

https://www.techrepublic.com/article/how-to-use-the-geography-data-type-to-q
uickly-add-a-map-chart-in-excel/

Susan H. 

-----Original Message-----
From: AccessD <accessd-bounces+ssharkins=gmail.com at databaseadvisors.com> On Behalf Of David Emerson
Sent: Thursday, September 9, 2021 9:04 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

Does anyone have any experience with telecom networks and mapping them visually.  I am talking with a potential new client who wants to store all the network items in a database and then portray them graphically.  Am I pushing Access too far for this?

David

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of David Emerson
Sent: Thursday, 9 September 2021 8:58 am
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Cc: 'Jim Dettman' <jimdettman at verizon.net>
Subject: Re: [AccessD] Access and Google maps

Thanks Jim,

Do you have any good pointers to code which interacts with the drop pins, customizes the icon etc?

Regards

David

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of Jim Dettman via AccessD
Sent: Thursday, 9 September 2021 8:28 am
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] Access and Google maps

<<
I have read that an Access web control will allow this to be done.  Is this the best way?
>>

 It's the only way.

 And yes, you can interact with the map, drop pins, allow them to double click on a point, etc.   But really, with the current web browser control, it's clunky.  Also when using the browser control, you need to override the emulation mode in the registry.   By default, it's IE7.  You can push it up to 11, but IE is now out of date.   Many sites will not longer allow for it.

 Microsoft is working on a replacement though.   Not sure when it will be released, but I believe it will be soon.

Jim.

-----Original Message-----
From: AccessD On Behalf Of David Emerson
Sent: Wednesday, September 8, 2021 3:27 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] Access and Google maps

Hi Listers,

I have a client that wants to have a google map in their Access application.  I have seen the google developer’s site with general information.

I have read that an Access web control will allow this to be done.  Is this the best way?

On the map they want to have icons representing different items (eg locations of manholes, Receiver towers, Control Boxes).  Can customised icons be used?

Does anyone know if it is possible to click on an icon and have other code run (eg pop up boxes with extra information)?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand