Hi there,
You are overcomplicating it.
1. No API key needed, you are not trying to interact with the Google maps API interface, you are simply passing a string (URL) to your default browser.
2. No need, see above.
3. Not applicable
4. Look at the code I originally gave you in post 6. strFrom is hardcoded in VBA, strTo comes from your form (Me.[CoordinatediPartenza). Use the strFrom from post
# 14 (I entered your original address in Google Maps and this is how Google formatted it). For strTo make sure it is also a valid address or place, copy it manually in Google Maps and see how it looks.
Don't mind it but I am denied in VBA code.I currently have this code tell me in the code line what is missing or what am I wrong?
Thanks and sorry again
Private Sub Comando340_Click()
Dim strFrom As String, strTo As String
Dim sMyAddress As String, sHomeAddress As String
On Error Resume Next
Can you show me what do you have for Me.[CoordinatediPartenza]? What exactly is in the CoordinatediPartenza textbox on your form?
Please use:
strFrom = "Via Antonio Locatelli, 18 24060 Castelli Calepio BG Italy" instead of "Via Antonio Locatelli 18 Castelli Calepio Bg Italia" (note the comma and the postal code)
Do you get an error and if yes what is the error number and/or description?
In the field [CoordinatediPartenza] there are the coordinates of a place and for each record there is its coordinate.
Example...
N45 ° 57.335 'E9 ° 30.141'
I could also post the database
Currently the code is written as follows
Private Sub Comando340_Click()
Dim strFrom As String, strTo As String
Dim sMyAddress As String, sHomeAddress As String
On Error Resume Next
My zipped file weighs only 297KB but I can't send it.
The error message is:
The following errors occurred:
MontagmaRar: invalid file, compress the file and tray again
My zipped file weighs only 297KB but I can't send.The error message is:
The following errors occurred:
MontagmaRar: Invalid file, please zip your file and tray again
How can I do?
I try to send only databases I also tried to send only database m it doesn't workI also tried to send only database m it doesn't work Is it probably too heavy?
Hi Luciano,
Please have a look at the attached file. I have changed the way the coordinates are stored (removed the space between the grades and minutes for both long and lat and moved the letter to the end instead of beginning). I also had to reverse the directions points as it seems Google needs to resolve the one with the coordinates first then show directions to your place. When trying in reverse I was getting errors saying it cannot find directions.
Perfect very kind ...
The only small problem is to have reversed the code of the coordinates as I copied those directly from the hiking program. that way I would have to manually edit them every time, unless there is a way to automatically convert them every time I insert them.
Sorry again I tried to enter the coordinates as I always did like this ... N46 ° 00.562 'E9 ° 29.511'
And it seems to work.
These days I feel it better.
For now thank you and we will hear from you again if you can help me with the project.
Please try this version, I have added a query that converts the coordinates into the proper format so you can continue to copy and paste from your hiking program.
Hi Luciano,
Here is an updated version that opens the gpx files in its native program (Garmin). Please note that I moved the file one subfolder up as you had it two "Tracce GPX" subfolders deep.
Cheers,
Vlad
Hi Vlad wait work on this file because it's the last one I'm working on. I am attaching the file.
Sorry you anticipated me at work.
Very good.Nuovo Progetto Montagna.zip
This is the evolving program with the start of the project to create a mask to filter the data I put. I did not insert the query you linked to me in the objects because with me the coordinates also work in the original formatting.
Hi Vlad ... Sorry one more thing ... Yesterday I forgot in a hurry to stop, I didn't tell you that clicking the "Upload GPX File" button the field on the left must return the name of the loaded GPX file. In this way I see the actual upload of the file in the database folder.
However, I think you guessed it was so.
Thank you and excuse me. Have a nice Sunday.