[AccessD] Access and Google maps

[Jim Dettman]

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com