Stuck! need help

  • Thread starter Thread starter t
  • Start date Start date
T

t

I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this that I
am completely lost so posting my code will do no good. Can someone provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000
 
t,

I think you are looking for...

http://allenbrowne.com/func-concat.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any number,
I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this that
I
am completely lost so posting my code will do no good. Can someone provide
a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000
 
It doesn't sound kosher! Why don't you explain why you want to do that. You
can't do anything with the data in that kind of format. Also, a textbox
probably won't hold all your data.

Steve
(e-mail address removed)
 
Steve said:
It doesn't sound kosher! Why don't you explain why you want to do that. You
can't do anything with the data in that kind of format. Also, a textbox
probably won't hold all your data.

Steve
(e-mail address removed)





.
Good Question. The reason I need all this data in this format is I need to add all of the coordinates for the county to draw a map for it in google maps and open layers map. As you can imagine, doing this manually for 500 counties is going to be overwhelming and I was hoping i can at least have the coordinates ready to be copied and pasted in the map maker software to expedit things a bit. I hope this helps.
Click to expand...
 
What about just creating a VBA routine to step through the records and append
all that data in that format into a text file.

I don't know enough about the map maker software, but if it allows import of
data you could probably build a file to meet the specifications for import
from the database.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
t said:
I have data for latitude and longitude for multiple counties which means I
have a lot of coordinates for each county(at a minimum a couple hundred
points). I have a form that has the county # and when I choose any
number, I
want all the coordinates to be posted in a text box next to each other
instead of having one coordinate on one line and the next on a different
line( I have already saved the coordinates in the table with a comma so no
help required there). I have tried so many different ways to do this
that I
am completely lost so posting my code will do no good. Can someone
provide a
sample code?
I want to do this 37.54952000 14.44425000,37.55200000
14.44479000,37.55244000 14.44510000 instead of
37.54952000 14.44425000
37.55200000 14.44479000
37.55244000 14.44510000
Click to expand...
 
Back
Top