Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Say I import a data file containing company names,....

This is a discussion on Say I import a data file containing company names,.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Say I import a data file containing company names, addresses, and number of employees at each address. How can i ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Say I import a data file containing company names, addresses, and number of employees at each address. How can i draw a polygon around a subset of these companies and find out total employees inside the polygon?
    (I know i could do Export to Excel each time i draw the polygon, then add the total within Excel, but I would like to eliminate that step and see the total while still in MapPoint).

  2. #2
    Walt Cygan is offline Senior Member Green Belt
    Join Date
    Aug 2002
    Posts
    124
    Use the "QueryShape" method. From MapPoint 2002 help for this method:
    <pre>
    'Find records in shape
    objshape.Select
    Set objRecords = objDataSet.QueryShape(objshape)
    objRecords.MoveFirst
    Do While Not objRecords.EOF
    lngCount = lngCount + 1
    objRecords.MoveNext
    Loop
    MsgBox "Number of records in shape: " & lngCount
    </pre>
    So, you'd have to be able to identify the shape that you want to query, or you could do this for all Shapes having geoFreeform as a type. Then replace the accumulation of records with an accumulation of the employees field.


    - Walt Cygan

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Possible to batch file/macro Import Data Wizard?
    By Oyjord in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-31-2005, 05:05 PM
  2. Import data from a file into Map Point using VB Code?.....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-29-2004, 01:48 PM
  3. Import NMEA-data from a file into mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-19-2003, 12:17 PM
  4. to import data of one access file into another using vb code
    By bushi_khan in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-14-2003, 02:12 AM
  5. Import data from a text file
    By Val in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-08-2003, 07:15 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83