MapForums

Anonymous · #1 (**permalink**) 02-09-2003

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

Anonymous · #2 (**permalink**) 02-11-2003

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

rmozes · #3 (**permalink**) 08-12-2003

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,

rbarthels · #4 (**permalink**) 08-12-2003

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

rmozes · #5 (**permalink**) 08-12-2003

Rainer,

10x for your help

schönen Tag noch

,

Ran

rmozes · #6 (**permalink**) 08-12-2003

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

rms62 · #7 (**permalink**) 08-14-2003

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

rmozes · #8 (**permalink**) 08-14-2003

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 Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using longitude and latitude to find adress	Edward_Carnby	MapPoint 2006/2009 Discussion	4	07-22-2008 08:12 AM
Data2Map is back!	dkrafcheck	News and Announcements	0	05-15-2006 09:11 AM
Complete adress, when using ShowFindDialog?	Jarun	MapPoint 2006/2009 Discussion	3	04-11-2005 01:31 PM
Getting back Autobahn-kilometers	rms62	MapPoint 2006/2009 Discussion	0	08-31-2003 06:33 AM
Adress to n-Adress calculating	rbarthels	MapPoint 2006/2009 Discussion	3	11-19-2002 04:07 PM

MapForums

Lat/Lon to MP and Adress back to Access

Lat/Lon to MP and Adress back to Access

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads