Hi Guys,
thank you for all hint's and suggestions.
I did what I want 🥳
Public Function mapaGoogle(ByVal plik As Variant)
Dim Mapa As String
With GPSExifReader.OpenFile(plik)
If .GPSLatitudeDecimal > 0 Then
mapaGoogle = "http://maps.google.com/maps?ll=" &...
Thank you.
My report looks like this. Every picture I have picture and url to high quality picture.
I want to add also link to GPS coordinates below it - just to open maps google with coordinates.
All my report is based on query where I download temporary pictures from url etc. And it is...
Hi Colin I know that you put all in #4 but maybe for you it is logical and easy but for me it is difficult and I don't know how to do this.
I tried few times creating vba code but still there is error in it. Only what work in my case is that vba code in load form not as public function which I...
Hi again, last question. (many thanks for replay)
I adapted code in form load and it works is looks like this.
Private Sub Form_Load()
On Error GoTo ExifError
Dim strDump As String
Dim filePath1 As String
filePath1 = "C:\test.jpg"
With...
Thank's but I don't have api key and I will not have it in future. So I need to create url to google maps not image of it.
Every record has about 20 url's... url1,url2 etc...
I want to save coordinates from Exif because my database create pdf report with picture inside and url to it, but I want to also and url to google maps with coordinates of picture. I hope I will manage with public function who will query coordinates from exif before final report in pdf :)
Unfortunately I have problem with creating public function e.g. PublicGetLatitude([name field]). I think it is easy but my mind doesn't work.
Is it possible that you will write how this code should look like? According of your code I will prepare PublicGetLongitude etc...
Thank you very much.
Thanks for replay I will try to manage with it :) Australian app I thought that: https://www.everythingaccess.com/tutorials.asp?ID=Extracting-GPS-data-from-JPEG-files Many thanks go to Australia's North Central Catchment Management Authority for allowing us to release this code publicly.
Main...
Hi thank's for replay but to be honest when I enter code of your app or "Australian app" I don't full know how to adapt code to query function.
I want to create function which I will put to queries like Latitude([table1].url). I already put to my database these three modules: GPSExifProperties...
Hi All,
I read a lot of articles about Exif coordinates in Access but maybe you have solution how to deal it in queries.
I know there is huge tool https://www.access-programmers.co.uk/forums/threads/get-current-geolocation-data-using-access.299932/
I have table like this
ID
URL
1...
Ok it was not main topic but I will explain. Sometimes there is error with refreshing table in Excel direct from Access. Excel block file and I see Excel process in Task Manager. I don't why. But now it doesn't matter this solution works perfectly. It better to download and replace csv than put...
Thank you for that link but I checked two solutions and it doesn't work.
My code looks like
Sub DownloadFile(url As String, filePath As String)
Dim WinHttpReq As Object, attempts As Integer
attempts = 3
url = "https://mysecreturl.com/fodjpdfjps"
filePath = "c:\baza\"
On...
Hi All,
I tried to find a solution on forum but I cannot.
I have CSV table which is located on internet: www.example.com/13423532534gfs?@#432
When I press on url I download CSV table. I cannot import CSV table from Web in Access so i decide to put link to it on Excel and I have a connection...
Ok I found solution.
At head of my code VBA I add
?HTTP_Get("https://mysecreturl/file.xml")
And now everything works ! Thank you very much for your help. Now I will not waste my life time to manually download. But to be honest I don''t know why it works in past and now it doesn't