If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Stuck! need help
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 |
#2
|
|||
|
|||
Stuck! need help
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 "t" wrote in message ... 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 |
#4
|
|||
|
|||
Stuck! need help
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 t wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201001/1 |
#5
|
|||
|
|||
Stuck! need help
Oops, forgot the link:
http://community.netscape.com/n/pfx/...apps&tid=24271 Ken Sheridan Stafford, England -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201001/1 |
#6
|
|||
|
|||
Stuck! need help
"Steve" wrote: 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 "t" wrote in message ... 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 . 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. |
#7
|
|||
|
|||
Stuck! need help
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 "t" wrote in message ... "Steve" wrote: 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 "t" wrote in message ... 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 . 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. |
#8
|
|||
|
|||
Stuck! need help
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 Gina Whipp wrote: t, Were you able to work with the code or is that not giving you what you want? |
#9
|
|||
|
|||
Stuck! need help
"t" schrieb im Newsbeitrag ... 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 |
Thread Tools | |
Display Modes | |
|
|