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

Lat/Lon to MP and Adress back to Access

This is a discussion on Lat/Lon to MP and Adress back to Access within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hallo I have an Access-Table with latitude and longitude and want to get back the Postcode, the City and the ...

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

    Lat/Lon to MP and Adress back to Access

    Hallo

    I have an Access-Table with latitude and longitude and want to get back the Postcode, the City and the Streetname form MapPoint to use ist in my project. Can anyone help me with a simple VB-Code?

    thanks

    Ralf

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Now I found the Article#50. I built the source code into my Progamm and it works well. However the
    speed is very slow, if no direct hit is landed. Does anyone know a
    possibility of increasing the speed? Thanks for each assistance.
    Ralf

  3. #3
    rmozes is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    7

    please help

    Hello ,

    i have a similiar problem.
    i have an ACCESS (mdb) table with info and I want to write the longitude and latitude of each place into this table using VB.

    i can already calculate the Long/Lat but how do i write it back into the table?

    please help,

  4. #4
    rbarthels is offline Member Green Belt
    Join Date
    Nov 2002
    Posts
    52
    Hi,

    I have written a program which gets the Latitude, Longitude from a
    given address. It also corrects bad choice from MP. You can download it from the MP-magazine.

    http://www.mp2kmag.com/articles.asp?ArticleID=98

    Rainer

  5. #5
    rmozes is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    7

    10x a lot

    Rainer,

    10x for your help

    schönen Tag noch ,

    Ran

  6. #6
    rmozes is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    7

    further help

    Rainer , I write to you again.

    Is it possible only to get the code part in which you communicate with the Access DB?

    I am not interested in the whole Geocoding story at the moment.
    I just want to see how can i export the LONG/LAT info to my Access table from every pushpin!

    10x

  7. #7
    rms62 is offline Junior Member White Belt
    Join Date
    Jun 2003
    Posts
    9
    Hi Ran,

    dim db as database, rs as recordset
    set db=currentdb
    set rs=db.openrecordset("DeineTabelle")

    rs.edit
    rs!DeinFeld=Lat
    rs!DeinFeld=Lon
    usw.
    rs.update

    ready

    In my application I take the lat/lon from a given access-table and write back the address - so I run a do until rs.eof Schleife.

    If you need more help then post again.

    Ralf

  8. #8
    rmozes is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    7
    Ralf,

    fisrt thanks, but maybe I should mention that I work with VB6 and that my mdb file should stay in background (i don't need it to be open, in fact i need it to stay closed).

    1. so how do I open it in background?
    2. The rs.edit is showed as an error (there is no such atribute as edit in my list)

    is it possible that your code was for .NET or maybe I passed something...

    thanks again,
    Ran

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using longitude and latitude to find adress
    By Edward_Carnby in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 07-22-2008, 09:12 AM
  2. Data2Map is back!
    By dkrafcheck in forum News and Announcements
    Replies: 0
    Last Post: 05-15-2006, 10:11 AM
  3. Complete adress, when using ShowFindDialog?
    By Jarun in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-11-2005, 02:31 PM
  4. Getting back Autobahn-kilometers
    By rms62 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-31-2003, 07:33 AM
  5. Adress to n-Adress calculating
    By rbarthels in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-19-2002, 05:07 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