A map activated from a form

[Johnathon Anderson]

I work in a school with a catchment area in Stevenage. Parents of children
applying for entrance for their children to the school’s extra curricular
activities must live between Farlands and Martins Ways (which basically
circumvents the town center). We have had to set limits as the activities
are very popular and so would be over-subscribed if limits were not set.

There is an on line application form that parents complete on the main
education authority website. After much insistence we have now got the
central data team to agree to supply this information to us in the form is an
access database table.

This table contains
ID, parent details, child details, activity details.

I have created a form to contain all the information sent to us and would
like to place a “very simple†method of checking if the address is within a
catchment area. If it is, we can add the details to the main table and send
the parents information concerning their child’s activity.

I have seen (somewhere, but I now can’t find it) a method of having a button
on a form that, when clicked, displays a map showing the location of an
address. This would be an excellent idea as it would allow the school’s
administration staff, very quickly, to see if the child’s location was within
the catchment area.

If anyone could e mail me the code I would be very grateful as I have been
not only searching for this code on the internet but have also spent many
days trying to work it out for myself (to no avail). Time is now pressing
and I “really†need to get this finished so I can present it to the governors
at the next scheduled meeting in a few days time.

Thank you very much for you time. If you need more information regarding
this project please let me know.

J Anderson

 

[Philip Herlihy]

I work in a school with a catchment area in Stevenage. Parents of children
applying for entrance for their children to the school’s extra curricular
activities must live between Farlands and Martins Ways (which basically
circumvents the town center). We have had to set limits as the activities
are very popular and so would be over-subscribed if limits were not set.

There is an on line application form that parents complete on the main
education authority website. After much insistence we have now got the
central data team to agree to supply this information to us in the form is an
access database table.

This table contains
ID, parent details, child details, activity details.

I have created a form to contain all the information sent to us and would
like to place a “very simple†method of checking if the address is within a
catchment area. If it is, we can add the details to the main table and send
the parents information concerning their child’s activity.

I have seen (somewhere, but I now can’t find it) a method of having a button
on a form that, when clicked, displays a map showing the location of an
address. This would be an excellent idea as it would allow the school’s
administration staff, very quickly, to see if the child’s location was within
the catchment area.

If anyone could e mail me the code I would be very grateful as I have been
not only searching for this code on the internet but have also spent many
days trying to work it out for myself (to no avail). Time is now pressing
and I “really†need to get this finished so I can present it to the governors
at the next scheduled meeting in a few days time.

Thank you very much for you time. If you need more information regarding
this project please let me know.

J Anderson

Interesting question. Google Earth, Google Maps and Windows Live Maps
all have API facilities - but you're not going to get this working in a
few days. You may be able to build a URL on the fly and submit that to
a browser or a web control perhaps. Autoroute can import addresses (from
Excel or Outlook) and display them as pushpins, and MapPoint can do a
lot more than this (I'll know exactly what when I find time to play with
the copy on my shelf!). If you had OS Grid information (no, this is
getting silly...)

However, the simplest answer could be to build a table of postcodes and
match on (or rather IN) that. Postcode data can be expensive, but you
may be able to get the data from the central data team, or even this:

http://www.octopusbooks.co.uk/phili...2/philips-red-books-stevenage-and-letchworth/

or this:

http://www.mapstop.co.uk/product3_02-South-East-England---Postcode-District-Map.aspx

Bear in mind that if you are making decisions about the supply of public
services based on data, that data has to be very clean and
well-structured. Can you pick out the right information from the
"parent details" as typed (often clumsily) into the web form? You
should only attempt this if you have very good quality data.

Phil, London

 

[Steve]

Take a look at MS MapPoint. It does what you want and can integrate with
Access.

Steve

 

[Wayne-I-M]

You would be better create a table will the postcodes then use a query (IIF)
to show if the applicationant is within your area. If not then.....

A map looks better to your govenors but the simple query will be a better
solution from a database design viewpoint.

If you really want the map and you have a field in the table called postcode
?? Create a button on your form and use this onClick


Private Sub ButtonName_Click()
Dim MyHyperlink As String
Dim strGoogleLoaction As String
'next stuff is all on one line'
strGoogleLoaction = Replace([postcode], " ", "+")
MyHyperlink =
"http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction & "&ie=UTF8&ll=51.912085,
-0.195694&spn=0.023349,0.054932&z=14&iwloc=addr"
'all above is one one line'
Application.FollowHyperlink MyHyperlink
End Sub



This will stevenedge between the roads you mention and a marker to show the
house