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 3 of 3

Please Help - Access VBA to Map Territories

This is a discussion on Please Help - Access VBA to Map Territories within the Development forums, part of the MapPoint Desktop Discussion category; I'm trying to figure out how to take a table in access an map it as a territory in access. ...

  1. #1
    graviz is offline Junior Member White Belt
    Join Date
    Aug 2009
    Posts
    9

    Please Help - Access VBA to Map Territories

    I'm trying to figure out how to take a table in access an map it as a territory in access. I've done some searching and and found some articles on MapPoint Articles - MP2K Magazine and in these forums but have had no luck with what I'm trying to do. Here's what I have:

    -A table called Office_Zips (two fields, Office Name, and Zip Code)

    This is my code so far:

    Public Function test_map()
    Dim oApp As MapPoint.Application
    Set oApp = CreateObject("mappoint.application.na.16")
    oApp.Visible = True

    End Function

    All I would like to do is have a new territory map created using the information in the table as the source.

    Thanks!

  2. #2
    Elgrande is offline Junior Member White Belt
    Join Date
    Oct 2009
    Location
    The Netherlands
    Posts
    6

    Re: Please Help - Access VBA to Map Territories

    Hi Gravis,

    Why use Visual Basic ?

    You could start mappoint and press the Territory button and link it to a database table.

    with Kind regards,

    Sander

  3. #3
    graviz is offline Junior Member White Belt
    Join Date
    Aug 2009
    Posts
    9

    Re: Please Help - Access VBA to Map Territories

    Quote Originally Posted by Elgrande View Post
    Hi Gravis,

    Why use Visual Basic ?

    You could start mappoint and press the Territory button and link it to a database table.

    with Kind regards,

    Sander
    I need to automate quite a few maps from Access. It needs to be in vba. That's how I'm doing it currently and it takes forever.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Territories
    By lacja in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-05-2006, 10:51 AM
  2. Territories creating city territories
    By cableghost in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 08-30-2005, 04:47 PM
  3. Territories
    By Circpro in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-20-2005, 06:23 AM
  4. Territories
    By Anonymous in forum Wish List
    Replies: 5
    Last Post: 03-12-2004, 03:22 PM
  5. Territories
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 01-09-2004, 02:49 PM

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 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127