[AccessD] Access and Google maps

[Rocky Smolin]

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
>