Help me with code thank you

[Pierre Garound]

Hello Mr and Mrs

I have code from this a employee of this forum to show locations on map of
France. It will not work for France only of England and America. I not want
to go from then to only to show location with point. But I think the code of
non-funtionals as it will not save wen I move the map to France. I can put
in Buckingham Palace but it will not work for any where in Paris - why is
this Microsoft.

I have ask of Forum in France but they do not this code know so they say to
ask you Mr and Mrs in this forum

Can you help me to correct this code please thank you.

This code is for England

Private Sub MapSearch_Click()
Dim MyHyperlink As String
Dim strGoogleLoaction As String
strGoogleLoaction = Replace([ZipCode], " ", "+")
MyHyperlink =
"http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction & "&ie=
UTF8&msa=0&ll=52.802761,-111.972656&spn=45.773251,118.476562&t=h&z=3&om=0&m­sid=103780121206034963667.00044460d57e1dea96b9d"
Application.FollowHyperlink MyHyperlink
End Sub

and for America I have this code

Private Sub MapSearch_Click()
Dim MyHyperlink As String
Dim strGoogleLoaction As String
strGoogleLoaction = Replace([ZipCode], " ", "+")
MyHyperlink =
"http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction & "&ie=
UTF8&msa=0&ll=52.802761,-111.972656&spn=45.773251,118.476562&t=h&z=3&om=0&m­sid=103780121206034963667.00044460d57e1dea96b9d"
Application.FollowHyperlink MyHyperlink
End Sub



? How do I make so France is on map when open

 

[Stefan Hoffmann]

hi Pierre,

MyHyperlink =
"http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction & "&ie=
UTF8&msa=0&ll=52.802761,-111.972656&spn=45.773251,118.476562&t=h&z=3&om=0&m­sid=103780121206034963667.00044460d57e1dea96b9d"
? How do I make so France is on map when open

This is a Google problem, go to the Google Maps pages. Take a look at
the parameters you have in your HTTP request...


mfG
--> stefan <--

 

[Pierre Garound]

I am apoligise I did not get the answer. Send again please thank you

 

[Stefan Hoffmann]

hi Pierre,

I am apoligise I did not get the answer. Send again please thank you

http://code.google.com/apis/maps/


mfG
--> stefan <--

 

[Pierre Garound]

Thank you Mr Stefan

I have look at this site before and it is very much complecate. Can I send
e mail to Mr Wayne-i-m who know about this so he can tell me how to make
France in the map. Is this possible at the microsoft.com forum

I am think that I must only alteration one section of the code to work.

I am learning much from the help of this forum. It is very good.

 

[Larry Linson]

I have look at this site before and it is very much complecate.

What you have is not a Microsoft Access problem, it is a Google maps
problem. This is not a Google maps newsgroup, it is the English-language
newsgroup for Microsoft Access, and, thus, most have experience in the UK
and the US (not surprisingly, the places where your code does work). If you
found someone here who had experience that you need, it would only be by
chance.

If Google maps is complicated, then you need to be prepared to expend the
time and effort to learn it so that it does not seem so complicated. Have
you searched the Internet for tutorials, or for newsgroups dedicated to
Google maps, or just Questions and Answers relating to Google maps? (A
Hint: you will not find a Google newsgroup via the Microsoft online user
interface you are using... you might find one at http://groups.google.com).
That would be learning that is of lasting benefit to you, also.

Can I send e mail to Mr Wayne-i-m who know about this so
he can tell me how to make France in the map. Is this possible
at the microsoft.com forum

No Microsoft employees are assigned to answer questions here. All the
people who answer are volunteering their time, expertise, and energy.
WayneIM is a volunteer and it is not considered polite to e-mail the
volunteers directly, unless they have invited you to do so. Many, just as a
matter of principle, do not accept e-mail follow-up messages. Some do, if
they have the time and energy. The Microsoft user interface does not provide
for sending e-mails to posters in the newsgroups.

Different people have different views on what is a reasonable use of
newsgroups, and what is reasonable to ask. Newsgroups, most agree, are good
sources to get specific help on specific issues; few responders will even
try to offer a general tutorial; and almost everyone who answers agrees that
it is not a place to get your work done for free, or for free detailed
consulting. To me, what you are asking seems it may fall in one of the last
two areas.

Larry Linson
Microsoft Office Access MVP
(for information about the MVP program, see
http://mvp.support.microsoft.com --
MVPs are not Microsoft Employees)