Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Google map links
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Google map links
Resolved · Low Priority · Version 2007
Reply
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.For upcoming training course dates see: Pricing & availability
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
Mon 2 Nov 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Pivot |
How do you create a pivot table
