microsoft streets and trips in access database

[Guest]

Is there a way to build a searchable map in Access using MS Streets & Trips,
or any other map program? I have thought about contacting Yahoo but I think
their engine is fairly expensive, and we already have multiple license for MS
S&T.

I have 1799 names and address stored in an Access db.
Here's what I would like to see happen:
1. The EU clicks a button that says STATE (will offer City, State, or Zip)
2. The query behind the button prompts of the name of the STATE
3. The EU enters an abbreviation, say TX
4. A map opens showing the location of all of the TX customers

An added bonus would be the ability to then search the same map for a new
address that is not in the db. The intention of course is to see who is
closest to the prospective address.

 

[Arvin Meyer [MVP]]

MapPoint, which is similar to Streets & Trips can be programed with VBA to
return maps and directions. You might like to visit the premier MapPoint
website to get more information:

http://www.mp2kmag.com/

 

[Armen Stein]

MapPoint, which is similar to Streets & Trips can be programed with VBA to
return maps and directions. You might like to visit the premier MapPoint
website to get more information:

http://www.mp2kmag.com/

We looked into programming Streets and Trips also, but apparently with
its lower price also comes the removal of object model programmability.
However, we've automated MapPoint from Access and it works very well.