Search results

Hi All, I finally got it to work correctly by applying a combination of everyone's suggestions. The biggest issue was the Acos function that had to be created in Access VBA. After that was incorporated into the function, it started working. Adding the SELECT DISTINCT to the query removed...

Jdraw....There are two Tables that comprise this project. Station Tower Data=80,000 Records Cell Tower Data= 3,000 Records The project is supposed to take a record from the Cell Tower Data get the coordinates of that Cell Tower and then search the Station Tower Database and output the Station...

Hi Jdraw....You are correct ! "Seems you are experiencing the very same issue that I was referring to in my post #6" Being a newbie with DB programs, I'm learning as I go, and making mistakes every minute How or where do I implement the "Lat/Lon Box".... I'm guessing that I have to filter out...

Hi All....I think I have my Coordinate Distance Query working somewhat...there is still a bit of a problem though. Each entry of Table A does a Query of every entry in Table B and calculates the distance...I would like to limit the output display to only those that are within a specified...

Hi Mark, Your post is similar to what I have been trying to do. Being a newbie, I'm not sure where to put the code. Should it be in a Macro ? or a Module ? BTW...the distance between coordinates would be 3 Km. In your function GetPolarDistance, how would I call that to get the sorting...

Hi All, I need help with distance and bearing calculation and display in Access 2007. I have two tables of data, Table A has Lat & Long coordinates in Decimal format ie: 42.123456 degrees lat, -80.123456 lon. and some other data in a few columns Table B also has coordinate data in the same...

Paul....I do not see Access included in the Office 360 services...so that triggered my question. I hope that it continues to be available for the future. Thanks

Hi all, I'm new to this forum and in fact new to MS Access. My background is in broadcast engineering and AM/FM radio engineering in particular. I have been an MS Excel user for many years but now I finally have decided to learn something about Access. People have told me that Access is on...

The math to calculate the distance is the simple part. I believe I have a code snippet that has that calculation covered. Turning the Excel Spreadsheet into an Access table is something I know how to do, so that part is easy and I would do this manually. Whenever I get an Excel file, which...

I have an Access database that contains Radio Station Call Letters and their associated radio tower coordinates. I will be receiving an Excel Table list of cellphone towers and their coordinates. What I need to accomplish is this: Each cellphone tower coordinate has to be compared to the...