[AccessD] Access and Google maps

[David Emerson]

Thanks Rocky,

In this case the application is to be sold to Telcos so it needs to be self contained (within the normal office 365 suite).

David

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Friday, 10 September 2021 1:24 pm
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

IME, I think so.  I can think of a couple really clever ways to do this. I remember when a friend and I were developing the first Critical Path Project Management System for personal computers and we had to figure out how to create a PERT chart.  Using CBASIC. On 8 bit machines. Well, we did it. But it was..."interesting".

The VBA approach would be similarly "interesting".

Does Visio interface with Access? Does it have an object model exposed in Access?  That, I think, may be a path.  But only if Access can speak to Visio like it does to Excel.

r


On Thu, Sep 9, 2021 at 6:04 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> 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