[AccessD] Access and Google maps

dw-murphy at cox.net dw-murphy at cox.net
Fri Sep 10 17:17:12 CDT 2021


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


--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list