Stuck! need help

[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

 

[Gina Whipp]

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

 

[Steve]

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)

 

[KenSheridan via AccessMonster.com]

You might also like to take a look at the following which demonstrates two
ways of doing this sort of thing in a report, using 'across then down'
multiple columns. The report/subreport solution is far simple than the
single report solution in which the layout is manipulated in code at runtime.

Ken Sheridan
Stafford, England

 

[KenSheridan via AccessMonster.com]

Oops, forgot the link:

http://community.netscape.com/n/pfx...libraryMessages&webtag=ws-msdevapps&tid=24271


Ken Sheridan
Stafford, England

 

[t]

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.

 

[Gina Whipp]

t,

Were you able to work with the code or is that not giving you what you want?

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

 

[John Spencer]

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

 

[0]

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