Google map links

The UK's most regular instructor-led training courses.
Training information: 2003 access micorosft training · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

1 post

ReplyFri 23 Oct 2009, 16:18Delegate Andy said...

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.

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

336 posts

ReplyMon 26 Oct 2009, 09:54Trainer Anthony said...

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.

· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Getting To Grips With Templates In Access 2007
· Getting to grips with Access 2007's Opening Screen and User Interface
· So You Want To Create Forms In Access 2007?
· MS Access can promote teamwork

Please browse our web site to find out more about
2003 access micorosft training and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips