spacer1
spacer2 1_1 1_2
2_1
 Subscribe
 The MP2K Update!
 
 
 
 Magazine
Front Cover
What's New
Articles
News
Sample Data
Gallery
Advertise
About
 Features
MapPoint 2013
Press Releases
MapPoint Forums
Companies
Link to MP2Kmag
Wish List
MapPoint Trial
Authors
 Earlier Content
Past News Items
Past What's New Announcements
 Sponsors
 Order

MapPoint 2013

Programming MapPoint in .NET

MapPoint Book

  Spatial Community
SVG Tutorials
MapPoint

Map Visitors

  ARTICLES  


Tracking P.F. Chang’s in the Midwest

A popular Asian-themed restaurant has opened dozens of locations throughout the U.S. This article demonstrates a simple MapPoint/Access application showing P.F. Chang’s locations in Illinois and Indiana.

This article demonstrates use of the MapPoint control on an Access form. We don’t do anything sophisticated, just walking through addresses in a table, geocoding them, and re-centering the map. We leave it to the reader to imagine and build off this to develop applications to suit your own needs.

First, take a look at the cuisine section of P.F. Chang's web site. This alone suffices as motivation for this article. Also see their new items.

Now, visit their locations section. (Note that for mapping, they are linking to external sites employing a combination of Yahoo! Maps and MapQuest. Imagine how it could look with MapPoint .NET integrated into the site at Dollar Rent A Car's store locator.) [ed. Note (08/02): it appears pfchangs.com is now using MapQuest exclusively]

For the purposes of this article, I grabbed the addresses and descriptions of the five sites in Illinois and Indiana and pasted them into an Access table.

Download the Access database (Access 2000 format) here. Use the record navigation buttons at the bottom left to walk through the records. The .mdb file consists of just two objects: the table and a form. Here's what the form looks like:

(Note that you can add and subtract your own records to the table making it a generic solution without need of programming knowledge or digging into the form's code and settings.)

Let's walk through the form code. The Form_Load section starts by instantiating the map and making the Navigation toolbar visible. It then adds a dummy pushpin as a work-around, not elegant, but it gets the job done and finishes by ensuring that all place categories are turned off simply for esthetic's sake.

The Form_Current subroutine is called each time the record changes. The first line deletes the old pushpin, the next line geocodes the address, and the following lines set the symbol and zoom to the location.

featured resources
- Restaurant architects & Restaurant Engineers - For Hire For Your Project Immediately


This prevents the control from prompting the user to save the map when the form closes.


Want to enhance or further this sample? Have a MapPoint/Access technique you'd like to show off? Submit solutions in .MDB format to website@mp2kmag.com for inclusion in our .MDB Circus competition before the July 31st, 2002 deadline to win a full copy of Microsoft MapPoint 2002.

Discuss this story in the forum.

Author: Eric Frost
Email: website(AT)mp2kmag.com
URL: http://www.mp2kmag.com
Eric is Editor and Publisher of MP2K Magazine and is a part-time student in University of Chicago's evening MBA program. Eric recently finished the MP2Kmag Guide What's New in MapPoint 2004.



Google
 
MP2Kmag Internet


 Recent Discussion
-numeca fine
-AutoColor
-SolidThinking Inspire v2016.1.5559 x64-BEAN (17/8)
-Auto FX PhotoGraphic Edges Ultimate Bundle Gen2 v9.6.0 (17/8)
-Mentor Graphics FloEFD 14.2-SSQ (17/8)
-Dlubal RFEM 5.06 (x64) Multilanguage (17/8)
-Bluebeam Revu eXtreme 2018.1 v18.x Multilingual (17/8)
-Autodesk Maya 2018.4 (17/8)
-Adobe Bridge CC 2018 (v8.1) x86-x64 Multilingual Update 2 (17/8)
-Simufact.Welding 4.0.1 (17/8)
-ANSYS Discovery Enterprise 19.1.1 (17/8)
-Aurora SPARK3D v2018
-ANSYS Electromagnetics Suite 17.1 (17/8)
-Solidthinking Inspire v2018.3.0.10526 Multilingual (x64) (17/8)
-Adobe Acrobat Pro DC 2018.011.20058 Multilingual (17/8)
-ANSYS Electromagnetics Suite 17.0 (x64) (17/8)
-GibbsCAM 12.0.29.0 (x64) Multilingual (17/8)
-Autodesk Autocad Mechanical 2019.1 by m0nkrus (17/8)
-Adobe Bridge CC 2018 v8.1 (x86/x64) Update 2 Multilingual (17/8)
-Autodesk AutoCAD Electrical 2019.1 (17/8)
-DS V5R22 CATIA-DELMIA-ENOVIA last hotfixes for all SP (17/8)
-VMware Fusion Pro 10.1.3 Build 9472307 (17/8)
-MAGIX Fotostory easy 2.0.0.35 Germany + English (17/8)
-Ds Simulia Abaqus v6.14-4 (17/8)
-Paragon Drive Copy 15 Professional 10.1.25.779 (x86/x64) (17/8)
 Resources
Browse GIS books and periodicals
Find a MapPoint Partner or Consultant
Real Estate Columbia MO Homes for Sale


Want Your Site To Appear Here?

   © 1999-2012 MP2K. Questions and comments to: website@mp2kmag.com
  Microsoft and MapPoint 2002/2004/2006/2009/2010/2011/2013 are either trademarks or registered trademarks of Microsoft.