[AccessD] Access and Google maps

Susan Harkins ssharkins at gmail.com
Fri Sep 10 17:31:59 CDT 2021


Well, this made me wonder if there isn't a third-party product that might do more. 

Susan H. 


Maybe that's why it's so easy. 😛

r
On Fri, Sep 10, 2021 at 2:49 PM Susan Harkins <ssharkins at gmail.com> wrote:

> Ah shoot... that's too bad. It's such an easy tool to work with.
>
> Susan H.
>
>
> 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-typ
> e-to-q
> uickly-add-a-map-chart-in-excel/
> <https://www.techrepublic.com/article/how-to-use-the-geography-data-ty
> pe-to-quickly-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
>
> --
> 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