[AccessD] Access and Google maps

James Button jamesbutton at blueyonder.co.uk
Fri Sep 10 18:06:22 CDT 2021


Maybe worth the effort of a chat to the local street and property control and authorisation authority - 
in the UK that would be the "local Government Authority"
They will be dealing with requests for installations of lighting and utility facilities - access points etc and have high resolution maps of their areas, 
that would include wiring ducts drainage and utility supply, and have to deal with things like the positioning of water supply stopcock access points, hydrants, 

So maybe there is an app they use that would be appropriate, and at a reasonable cost as it would already exist.

JimB


-----Original Message-----
From: AccessD <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of Susan Harkins
Sent: Friday, September 10, 2021 11:32 PM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access and Google maps

I'm also wondering (into the bourbon) why a client would be willing to pay so much to customize such an odd request when there's probably something cheap already out there. 

I also took care of my great grandbaby while their parents took a quick vacation. 

I'm .... numb. 😊 

Susan H. 


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

--
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