Prev: How can I activate the Access07 ribbon?
Next: Calculations in Group Footer
From: t on 25 Jan 2010 21:17


"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
> santus(a)penn.com
>
>
> "t" <t(a)discussions.microsoft.com> wrote in message
> news:CB988899-3509-4FD8-8BEF-E9056FE3F1CF(a)microsoft.com...
> >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.
From: Gina Whipp on 25 Jan 2010 21:20
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" <t(a)discussions.microsoft.com> wrote in message
news:82AABA7A-67B0-44C0-9C6E-FF79275C0D4D(a)microsoft.com...


"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
> santus(a)penn.com
>
>
> "t" <t(a)discussions.microsoft.com> wrote in message
> news:CB988899-3509-4FD8-8BEF-E9056FE3F1CF(a)microsoft.com...
> >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.


From: John Spencer on 26 Jan 2010 08:14
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?
>
From: 0 on 6 Feb 2010 10:01


"t" <t(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:CB988899-3509-4FD8-8BEF-E9056FE3F1CF(a)microsoft.com...
> 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
>
First  |  Prev  | 
Pages: 1 2
Prev: How can I activate the Access07 ribbon?
Next: Calculations in Group Footer