Andy has attended:
Access Introduction course
Project Intro Intermediate course
Access Intermediate course
Google map links
What is the best way to create a link from Access to a Google Map (or similar). I have a contact database and want to be able to link straight out to Google Maps based on the addresses in it.
RE: Google map links
Hi Andy, thanks for the query. First of all you need to make sure the datatype of the postcode field is changed to hyperlink. That will change your postcodes to blue and underlined. Right click on each postcode and Edit Hyperlink, changing the address to (in the case of WC1A 2LP):
http://maps.google.co.uk/maps?q=WC1A +2LP
The result will be a postcode hyperlinked to the corresponding Google Map. Now I know your next question is "how do I do this for hundreds of postcodes?" The answer is with a macro. You can record hyperlinking one postcode in this way, then edit the code acordingly and get the computer to loop through each postcode. We can come up with this at the end of the Advanced course if you like, or else give the office a call and we'll generate it for you if you run into problems.
All the best,
Anthony
