VBA for GPS Coordinates

[manda]

Hello,

I have a data entry form that I want to add a button that once 'hit' will GET the XY coordinates from a gps connected to my laptop.

I have done v. basic access ie d basic commands and i can query my data, set relationships etc

Thanks very much, Amanda

 

[jdraw]

Please describe in step by step fashion what happens when.
First...., then.....

Have you considered using Google Maps or Google Earth? THese may not apply, but it is unclear (to me at least) how connecting your gps to laptop fits exactly.

You're trying to find the x y coordinates of locations, or are these locations you have visited????

 

[Rx_]

This is not a recommendation for the software. Please conduct your own due-diligence.
http://www.freedownloadmanager.org/download/access-vba-code-google-earth-4538745.html
This is simply an example of software that links something like Google Earth to something like Excel.

On CNET - MarshallSoft GPS Component for Visual Basic (about $115.00)

MSDN has an extensive article on the Java Class object interface however, it would most likely be beyond your stated abilities.

My best guess is for you to define how you want the solution to behave. e.g. Open Google Earth (or Microsoft Bing) and click on a location, have that location moved into an Access table (or form).
Once your solution is defined, research the various tools and contact the companies.
It would appear that a interface will cost around $100 USD. Make sure it includes a "run-time" or "distributed license". In other words, don't pay $100 for each user's workstation.
There may be "free" versions, the support for "free" will probably reflect the price.

There are times it is preferred to design your own, and times to pay for the combined efforts, success, failure and support of a paid interface. My best guess is that this is not a standard interface for a beginner or mid-level programmer. That said, I would love to be proven wrong.

And, please share your findings / questions. GPS is on my "to-do" list for 2014.

 

[manda]

@jdraw -
i am in the field (rural isolated Australia) i have a data entry form that i use to fill in fields such at time, date, species of anaimals ie birds reptiles etc, description of vegetation and other observations.

i have a gps that is connected to my laptop because i need exact coordinates - i use this for GIS functions when i am back home ( i am comfortable with this part). i am also running QGIS so i can see where i am in relation to other layers ie aerials, vegetation roads etc.

normally i read the coordinates off the gps and manually enter them into the data entry form - this is the part i want to automate.

i have found lots of information out there but much of it is reams of code without explanation ie i dont know which bit does what and cannot therefore work out why or how it works. thought i would post here so i could learn how to do it

 

[manda]

This is not a recommendation for the software. Please conduct your own due-diligence.

This is simply an example of software that links something like Google Earth to something like Excel.

On CNET - MarshallSoft GPS Component for Visual Basic (about $115.00)

MSDN has an extensive article on the Java Class object interface however, it would most likely be beyond your stated abilities.

My best guess is for you to define how you want the solution to behave. e.g. Open Google Earth (or Microsoft Bing) and click on a location, have that location moved into an Access table (or form).
Once your solution is defined, research the various tools and contact the companies.
It would appear that a interface will cost around $100 USD. Make sure it includes a "run-time" or "distributed license". In other words, don't pay $100 for each user's workstation.
There may be "free" versions, the support for "free" will probably reflect the price.

There are times it is preferred to design your own, and times to pay for the combined efforts, success, failure and support of a paid interface. My best guess is that this is not a standard interface for a beginner or mid-level programmer. That said, I would love to be proven wrong.

And, please share your findings / questions. GPS is on my "to-do" list for 2014.

Hello i want to learn how to do it....

i have found a few free things that work really well i cant post a link because i have to have written more than 10 posts - on laptop world some one has written a function that saves gps to a csv file maybe i can use that behind the button and then i need to add a function that automatically loads the csv file