Can you incorporate a map showing project locations in access 2007

[JLDLS]

I am setting up my various projects/jobs in an access database, but wanted to
be able to view them on a map as well. Possible google earth or microsoft
virtual earth, or even mapquest. Is there a way to do this?

 

[Arvin Meyer [MVP]]

I suspect that there is a way. I use MapPoint with automation and get Access
working fine. You may need to automate with Outlook which uses Expedia.

 

[Wayne-I-M]

Hi

For the Maps with acces - I have never used this in my apps but I have
downloaded the sample and played with it. It is brilliant fun. You need to
log in and then download the module but its very simple.

http://www.utteraccess.com/forums/s...re=&Zu=&Zd=l&Zn=&Zt=2&Zs=a&Zy=#Post582734&Zp=

 

[Wayne-I-M]

Hi again

I have never really looked at this before - so this is just a first (2 min
coffee break) attempt. You can get anyones location as long as you have the
post code (not sure how it would work in the US or elsewhere)

I assume you have a control called "postcode" somewhere on your form.

Just create a lable with this OnClick - Yes I know it's a mess but it works
- I may clean it up when I've got another coffee break (get rid of all the
Mid - postcodes, like I said, 1st stab at this)

Oh and this is really fun.

Private Sub LableName_Click()
Dim MyHyperlink As String
MyHyperlink =
"http://maps.google.co.uk/maps?f=q&hl=en&geocode=&time=&date=&ttype=&q=" &
Mid([CDPostcode], 1, 1) & Mid([CDPostcode], 2, 1) & Mid([CDPostcode], 3, 1) &
"+" & Mid([CDPostcode], 5, 1) & Mid([CDPostcode], 6, 1) & Mid([CDPostcode],
7, 1) & Mid([CDPostcode], 8, 1) & Mid([CDPostcode], 9, 1) &
"&ie=UTF8&ll=53.443899,-3.158569&spn=0.695244,1.851196&z=9&iwloc=addr&om=0"
Application.FollowHyperlink MyHyperlink
End Sub

Give it go -