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

using an excel record as a variable

This is a discussion on using an excel record as a variable within the MapPoint Desktop Discussion forums, part of the Map Forums category; I export (programmatically) from excel to mappoint. There are, say, four fields: Order number; Name; Postcode; week number. This maps ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    using an excel record as a variable

    I export (programmatically) from excel to mappoint.
    There are, say, four fields: Order number; Name; Postcode; week number.
    This maps fine.

    I am trying to associate the week number of each record with a pushpin symbol number.
    How do I use or access the individual records in the fields?

    I have thoroughly searched your Q &A, picked up many tips, but no clues to solve this problem.

    I am fairly new to programming.

    I have tried to adapt this code but can only get field names.

    Code:
    Sub GetAllFieldNames()
    
      Dim objApp As New MapPoint.Application
      Dim objDataSet As MapPoint.DataSet
      Dim objFld As MapPoint.Field
      Dim strFldNames As String
      
      'Set up the application
      objApp.Visible = True
      objApp.UserControl = True
      
       'Let user create a data map
            objDataSet = _
              objApp.ActiveMap.DataSets.ShowImportWizard
    
      'Loop through all available fields for their names
      For Each objFld In objDataSet.Fields
        strFldNames = strFldNames & objFld.Name & vbCrLf
      Next
      
      MsgBox "DataSet field names: " & vbCrLf & strFldNames
    
    End Sub
    Using Mappoint 2004, Excel 2003, VB.Net

    Many thanks

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Try this

    Dim objrecordset as MapPoint.Recordset
    Set objrecordset = objDataSet.QueryAllRecords

    Now you can access: objrecordset.Fields.Item(n).Value


    Hope is usefull.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Marvellous—just what I was looking for.
    Thanks very much for your help.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Are there any workarounds for the 10000 record lim....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-23-2005, 06:01 PM
  2. Color coding locations by some variable, i.e. sales dollars
    By mr4tno in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-17-2005, 10:15 AM
  3. gps record
    By bchara in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-23-2004, 08:31 AM
  4. 50,000-record limitation
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 02-06-2004, 11:41 AM
  5. PUSHPIN RECORD LIMIT
    By gsc1ugs in forum Products: Pushpin Tool, Single State Mapper
    Replies: 2
    Last Post: 03-07-2003, 11:00 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