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).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment