nafty
asked on
united states map reporting
my boss has asked me to create a report with a map of the united states as shown at this web address http://www.yourchildlearns.com/us_map.htm. what he wants is to show a dot in a state that has a contact record and next to the dot show the contact name from the database.
does any one have a way to do this??
thanks
does any one have a way to do this??
thanks
Hey, man,
Be aware that most of the world is outside the US.
First of all, are you working with the website, or just a map that looks like that?
If the latter than you could prepare a map with precise colours for each state and let the point(x,y) value determine the chosen area. If you are forced to have the same colour value for different areas, then you must map the distinction in code:
Function StatetSelected(x a single. y as single) as integer
Select Point(x,y)
Case vbRed
If x > 100 and x < 300 and y > 500 and y < 600 then
StatetSelected= MyConstWyoming
Else
StatetSelected= MyConstFlorida
end if
etc
Be aware that most of the world is outside the US.
First of all, are you working with the website, or just a map that looks like that?
If the latter than you could prepare a map with precise colours for each state and let the point(x,y) value determine the chosen area. If you are forced to have the same colour value for different areas, then you must map the distinction in code:
Function StatetSelected(x a single. y as single) as integer
Select Point(x,y)
Case vbRed
If x > 100 and x < 300 and y > 500 and y < 600 then
StatetSelected= MyConstWyoming
Else
StatetSelected= MyConstFlorida
end if
etc
You mentioned a report. What kind of report? If you mean a printed report, then I'd think Visual Basic isn't the best way to go. If you mean something interactive like the web page with the map, then you could modify the Javascript routine that map pages uses to display the capitals.
ASKER
DarkoLord, i like your suggestion can you give me a little more to get started with
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can put this image into a picturebox, and store the coordinates for each state... then want you want to display the contact, you can draw a dot on a picturebox on a state's coordinates... then create a new label (create lable array first), fill it with data and move it to same coordinates... just ask if you need more specific help...
Darko