how to calculate distance between 2 points

[BreakdownBrian]

How do I calculate the distance between a postcode recorded in a table and another fixed postcode eg "SK1 2HH".

I need my Db to do 2 things:
1)show distances between two points as outlined above
2)a google map location of the postcode in the table by clicking a button.

I've got absolutely no idea on how to go about doing this?

Anyone that could provide an idiots guide Id greatly appreciate it.

 

[jdraw]

I provided a database for similar situation in post5 at
http://www.access-programmers.co.uk/forums/showthread.php?t=225339

Post back if questions.

You should read through the posts in that thread, there are some points that are important, and also look at the jpg in post 24

 

[BreakdownBrian]

Hi JDraw,

Wow that's excellent coding, my issue is I cant code!

which bits of code do I need to change to reference a textbox on the form that has a postcode and which to reference the specific postcode that I'm comparing distances to, this postcode doesnt appear on the form.

Also the textbox on the form that shows a postcode, how do I get this to open a googleMap of this postcode location when I press a button?

Furthermore, can I feed the distance value into the original table used?

Id greatly appreciate your help with this I am completely new to all this as you can tell.

 

[jdraw]

The database was meant as a sample to show how something could work. Details were left to your own creativity.

If you have a sample database with postal codes and a form, then post it in mdb format and I'll take a look.

 

[BreakdownBrian]

think I may just have resolved it!

Thanks for all your kind help jDraw, its much appreciated

 

[jdraw]

Glad to help. Good luck with your project.