在访问表单上实施Google地图 [英] Implement Google Maps on a Access Form

问题描述

我正在寻找开发具有Google地图集成功能的MS Access表单的帮助，以便我们的驱动程序可以查找一个停靠点，并确切知道它基于Google地图的位置。

我有wireframed（基本模型）它是这样的：
map http://i49.tinypic.com/35a6jki.png

所以我的问题是，我该如何做对屏幕的一侧（地图），基于左侧的信息填充？我需要传递值吗？此外，地图是否会自动生成，或者用户是否必须点击一个按钮才能使地图显示出来？

按钮DIRECTIONS FROM SEARS TOWER只是一个填充符，并将成为我们所在位置的按钮。我打算将这个开放视为另一个窗口。

想法？再次感谢StackExchange：D

解决方案

上面的评论表明你很快就会解决这个问题。谷歌地图使用+符号作为空间的替代品。您提供的youtube视频链接为超链接显示了一个很好的构建器。更通用的解决方案是将浏览器的控制源字段设置为：

  =https://maps.google .COM /地图？ &安培;替换（[Address]，''，'+'）& ，+&替换（[City]，''，'+'）& ，+&替换（[State]，''，'+'）& ，+& [b] 
  

I'm looking for help on developing a MS Access form that has Google Maps integrated so that our drivers can look up a stop and know exactly where it is based on the Google Map.

I have wireframed (basic mockup) it like this: map http://i49.tinypic.com/35a6jki.png

So my question is, how can I make the right side of the screen (map), populate based on the information on the left? Do I need to pass values? Additionally, can the map auto generate, or would the user have to click a button to make that map appear?

The button "DIRECTIONS FROM SEARS TOWER" is just a filler, and would be a button for where our location is. I'm envisioning that opening as an another window.

Thoughts? Thanks again StackExchange :D

解决方案

Your comments above show you are well on the way to solving this one. Google maps uses + signs as replacements for spaces. The youtube video link you provides shows a nice builder for the hyperlink. A more generic solution would be to set the Browser 'Control Source' field to:

="https://maps.google.com/maps?" & Replace([Address],' ','+') & ",+" & Replace([City],' ','+') & ",+" & Replace([State],' ','+') & ",+" & [Zip]

这篇关于在访问表单上实施Google地图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！