location search.

[Homegrownandy]

This may not be a possibility in access at all. But when websites have a "store locator" I would like to implement something similar for hospitals.



So when we are given a list of postcodes it will automatically find the nearest hospital in the database. (all hospitals in the area we cover have been entered). Ill investigate the javascript and PHP for similar things, but does anyone know if something like this can be done in access?

Thanks.

[ranman256]

You could call Google map search using the zip code.
do it in google then apply the URL to a button in vba.

[orange]

This thread may be of interest.

[Homegrownandy]

But google wont show me the nearest hospital. It will just show me the location of what I enter right?
there are a few wordpress apps I have seen. That will allow me to do this.

Maybe I'm asking too much (or know too little) in access.

The NHS here (national health service) do have this facility but... It only searches 15 miles from any location you enter.. and also it shows things I do not wish to see. So automating that procedure wouldn't work.

I might just do a local wordpress app. OR....

Just thinking here:

We have quite a lot of data now. perhaps there is a query that could see the first 3 letters of a postcode. If that exists on another record then use the same hospital ID...

[Homegrownandy]

Orange, Just briefly looked at that and wondering how I could apply it. If it shows distance, I could have it query the postcode/zipcode I enter then return the one with lowest value?

[orange]

That's the concept.
If you have the location address, postalcodeZip or lat/lon of each hospital, and the current location addr/zip or lat/lon, you can quickly calculate the "route" with minimal distance.

[Homegrownandy]

I like it, The Map function doesn't work as it should, but I have that working already.

Its great how it returns the values as it does though, Thanks.