If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wayne-i-m or someone else for Tranformation of Unicode
To Sir
We are send postage to Untied States and have need to “see” on map where desired recipient will be. This is so we know the postage area rate for DHL. You know that DHL website will give this but we need to check the desired location is correct cost. I am have a transformation format code, for an example of our code is like this. http://maps.google.com/maps?hl=en&ie...,89.648438&z=4 and I add to it with code like so and it will not work. Replace([txtZipCode] & MyHyperlink, " ", "+") Why not, this is very simple and it must work please We have e mail to Google but the say this is MS Access problem so they will not help. We e mail to Microsoft and they say this is Google problem so they also will not help. We have looked on many websites and the answers given are mostly simpley wrong as the author does not really understand what they are saying or (in some case) the answers are thinking we have different application than MS Access so answer will work with other application but not with MS Access which is what we have in here. What is wrong please as you are expert and we have great need to know this and for speed please. We can make payment for assistance if this is required and will need details for this. Yours truly Dim Ol Quok |
#2
|
|||
|
|||
Wayne-i-m or someone else for Tranformation of Unicode
Hi
I take that you want to see a map of the whole of the USA (looking at you UFT - this is what you have ??). In the code below I have changed .com to ..co .uk as this seems to work fastter (don't know why) Add a text box to your form (called txtZipCode ) Add a button with this OnClick (change ButtonName to what it is) Private Sub ButtonName _Click() Dim MyHyperlink As String Dim strGoogleLoaction As String strGoogleLoaction = Replace([txtZipCode], " ", "+") 'all of the below goes on one line' MyHyperlink ="http://maps.google.co.uk/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" & strGoogleLoaction & "&ie= UTF8&ll=38.68551,-93.164062&spn=31.865411,89.648438&z=4" Application.FollowHyperlink MyHyperlink End Sub Now when you type in a zip code into the box and click the button google maps will open with the pointer shown. for a list of all USA zip codes go to this site (the will be others) http://www.mongabay.com/igapo/ -- Wayne Trentino, Italia. "Mr D Quok" wrote: To Sir We are send postage to Untied States and have need to “see” on map where desired recipient will be. This is so we know the postage area rate for DHL. You know that DHL website will give this but we need to check the desired location is correct cost. I am have a transformation format code, for an example of our code is like this. http://maps.google.com/maps?hl=en&ie...,89.648438&z=4 and I add to it with code like so and it will not work. Replace([txtZipCode] & MyHyperlink, " ", "+") Why not, this is very simple and it must work please We have e mail to Google but the say this is MS Access problem so they will not help. We e mail to Microsoft and they say this is Google problem so they also will not help. We have looked on many websites and the answers given are mostly simpley wrong as the author does not really understand what they are saying or (in some case) the answers are thinking we have different application than MS Access so answer will work with other application but not with MS Access which is what we have in here. What is wrong please as you are expert and we have great need to know this and for speed please. We can make payment for assistance if this is required and will need details for this. Yours truly Dim Ol Quok |
Thread Tools | |
Display Modes | |
|
|