Thursday, January 26, 2012

How can I use addresses from an access database to map the location using Yahoo! Maps.?

I would like a command button on the form to perform this operation. The street address, city, state, and zip code are all in separate fields in each record.How can I use addresses from an access database to map the location using Yahoo! Maps.?
Use a label or text box to create a hyperlink to:

http://maps.yahoo.com/broadband#mvt=m %26amp;q1=%26lt;data%26gt;

(remove the space between 'm' and '%26amp;')



Replace %26lt;data%26gt; with the data from your database: "[street] [city] [state] [zip]"

This will create a link to Yahoo Maps, searching with the given address fields, which should get an exact location.

For safety, you may want to encode HTML entities (for starters, repace spaces with %20).

No comments:

Post a Comment