[AccessD] Access and Google maps

[David Emerson]

Hi Jim,

Your code may be useful.  I did find enough to tell me it can be done.  Just need to wait for the client to decide to go ahead, then I can immerse myself into the wonderful world of google maps 😊

Regards

David

-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of Jim Dettman via AccessD
Sent: Saturday, 2 October 2021 12: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

David,

   Have to apologize a bit....just found this reply to your e-mail that got stuck in my phone.

   I was on vacation and for some reason, it never went out.   My reply was:

---------------------------------
Sorry for the late reply.  I'm off on vacation right now.

I didn't do any code for dropping pins myself, but I did see them in the Google maps API and it seemed pretty straightforward. I'm sure there is code floating around for that.

I'll dig out the code I did do, but really it wasn't all that much.    I
display a Google map with points of interest, and a user can click on a spot
and get the info.   Along with that, I pull of the lat/long to store as the
location of an event.
---------------------------------

Hopefully you've had some success with this already, but if I can help in any way, let me know.

Jim.

-----Original Message-----
From: AccessD On Behalf Of David Emerson
Sent: Wednesday, September 8, 2021 4:58 PM
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