Reading GPS Coordinates into access web app

Question

Hi, I am trying to develop an application to track visits to our customers sites (security jobs). I need to be able to prove to the client that someone actually been at his site at a certain time.

I believe this can be done easily if I can put a button or comand to record gps coordinates and time in specific fields. However, I couldn't find any way to do this in access web app. It may be done with some VBA code in desktop version though.

I am using ipads for web app. There is a way to achieve this?

Thank you very much for your help.

Answer 1

There is nothing built-in, but you could conceivably write an "App for Office" https://code.msdn.microsoft.com/officeapps and host it on a page.

---

-Tom. Microsoft Access MVP

Answer 2

Hi u2luci,

Did you want to click a button to get the detail location of users? If I understood correctly, it is a little hard since users may using computer instead of iPads to access the web app.

And if you do want to get the location through the iPads, I suggest that you can get support from Apple Inc to see whether it provided the JavaScript API so that we can integrate with Office add-ins.

Hope it is helpful.

Regards & Fei

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 3

Hi Fei,

Thanks for your answer. We will use only iPad for getting the location, no desktop computer will be used for this purpose. Is there any way to record the coordinates into a table, is all that I need, as we need to prove the attendance on a specific time.

Your help will be much appreciated.

Answer 4

The "Office add-in" that Fei is hinting at is the same thing as the "App for Office" that I was writing about. They are written using JavaScript and HTML. If you can't find an existing one, you would have to write one yourself.

---

-Tom. Microsoft Access MVP

Answer 5

Tom, thanks for your answer.

Unfortunately I don't have any ideea how to do this. I will look into apps for office, but I don't think there's something close to what I need. I believe Microsoft could create some  add ins for Access to make it more useful, as browser version have a lot of limitations if you compare with the desktop one/

Answer 6

Hi u2luci,

Based on my understanding, the requirment for getting location from the device is more realtive to the device developing instead of the Access.

Micrsoft Access is an application base on client database which enable users developing client application associate with the database. And the Access 2013 web app is a new application model that enables subject matter experts to quickly create web-based applications.

To implement the requirment, you can choose the Office add-in(apps for Office) to extend the Access 2013 web app. And whether it is possible achieve the goal depnds on whether the device public the JavaScript API to get the location from the device since the Office add-in using web technolge(HTML, JavaScript).

And if you were request a full samlpe, you can try to submit the request from link below:
https://code.msdn.microsoft.com/site/requests

Regards & Fei

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.