[AccessD] Access and Google maps

[Rocky Smolin]

Now I;m trying to remember how we did this in 1983 so it's a little hazy.
But we divided the report into a grid of cells into which the activities
(in your case nodes and other assets I suppose) we're placed.  Then lines
are drawn connecting them.

If you can get the nodes, etc., placed in a grid then programmatically you
can draw lines between them.

Would love to work this one.  This is one of the reasons I became an indie
Access developer - I worked with scores of companies - all different - with
different problems to solve. Kept it interesting.

r

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

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>