gps

I have an Access DB that can (in Windows10) get data from a GPS receiver assigned to a com port. The organization has decided to upgrade our computers to Windows 11, now Access/VBA no longer understands the data coming from the GPS receiver. I am adding an image showing the "data" Access sees...

Hello! I have a column of GPS coordinates in DMS style (like this: 31°59'42.5"N 87°17'37.0"W) but for some reason they won't upload to ArcGIS, so I was told to try changing them into decimal degrees (like this: 30.9951389, -87.29361). Is there a way to have Excel do the change automatically? I...

Hi guys, I'm been reading and looking for a solution for this but I'm struggling, so I decided to ask for help. Imagine I have a list of coordinates and I would like to have the distance in meters from each other. Example: coordinate1 - distance to coordinate2, coordinate3, coordinate_n...

Hi, I am working on a data set which manages positions for landing sites. I need to be able to format positions in 2 different ways, one as Degrees Decimal Minutes (including symbols), and the other as Decimal degrees (+ and - based on E/W). The positions are entered in an info sheet for each...

I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and...

Dear forum. I have made an Excel sheet, where I entered (copy-pasted) gps coordinates from Google Maps. The column settings in Excel were not adjusted from the beginning, because I couldn't seem to find the right setting. This means that the current format is e.g. 55.419.474 10.455.039 and...

Hi I have a worksheet that lists physical locations and 2 respective columns that display the latitude and longitude coordinates for the location in that row. I am trying to automatically generate a respective URL in the cell adjacent to the coordinates columns that displays the complete URL...

Hi Dear Friends, Does anybody know how I can use VBA to get the coordinates of a point using a GPS or a Satellite? If Access/Excel cannot do this on their own, probably there is an ActiveX control somewhere that can be plugged in? Thanks in advance Sam

Hi all, I have just entered into the 5th year of a predator trapping project. All prior work is quite a mess, and massive. The project began with ~ 100 traps in a valley, each one given a numerical name. At random intervals, additional traps have been set up in this valley, also given...

Hello, I want to write a macro that gets the XY location from a GPS connected to my computer via a serial port. is this possible in excel, maybe i need to go to Access? Thanks Amanda

I am given a spreadsheet with 1 column. In this column, is a long string containing a variable list of gps coordinates. The syntax of the string is always the same, like this: LINESTRING(lat lon, lat lon, lat lon) My problem is that I need to switch each coordinate to be lon lat instead of...

I have been looking through a lot of very similar threads on this particular subject but have thus far been unable to find a solution that works for me. I imagine that there is something on these forums that would work but I figured it couldn't really hurt to try posting my own thread. I have...

Help! Inexperienced with Excel. Need Excel 2007 formula(s) to convert longitude/latitude coordinates such as "N48-38-46.5" and "E088-19-14.4" into Degrees Minutes decimal format. All longitudes are N, and all latitudes E. Long/lat have separate columns. The N's and E's are followed by...

Hi everyone I'm trying to put together a sheet where a user can enter data into four cells (N,S,E,W via drop down list in the first box, degrees, minutes and seconds in the remaining three). Ie. S ## ## ##.## The formula =G4+(H4/60+I4/3600) then converts the data to a decimal value which...

I would like to know if there is an easy way to capture coordinate data (lat, long, date/time stamp, etc) in an access form while using a tablet PC equipped with a usb GPS unit. I may need to collect up to 10 discrete location points per record. Any help with this would be appreciated. Thanks.