WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

GPS -> Access query

 
   Home -> Office other -> Getting Started RSS
Next:  object bound to table 'Contacts' is open or...  
Author Message
mick

External


Since: Aug 24, 2008
Posts: 6



(Msg. 1) Posted: Sat Aug 30, 2008 1:15 am
Post subject: GPS -> Access query
Archived from groups: microsoft>public>access>gettingstarted (more info?)

Can I connect my etrex to a notebook and (in real-time) have the track log
points saved into a table and displayed on a (continuous) form.

Has anyone done this - I have seen some questions about this but not seen
any workable answers.

Cheers

Mick
Back to top
Login to vote
Arvin Meyer [MVP]

External


Since: Feb 26, 2004
Posts: 4454



(Msg. 2) Posted: Sat Aug 30, 2008 8:17 am
Post subject: Re: GPS -> Access query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I have no idea what an etrex is, but in general, you need an output to
either a serial, or more likely a USB port. Ask the manufacturer of your
device if he can provide this output. If so, and it will output plain text,
you should be able to click in an Access text box and deposit your data.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"mick" <mick DeleteThis @discussions.microsoft.com> wrote in message
news:CBE23146-9BFC-41F2-B1FE-A5635CE3745F@microsoft.com...
> Can I connect my etrex to a notebook and (in real-time) have the track log
> points saved into a table and displayed on a (continuous) form.
>
> Has anyone done this - I have seen some questions about this but not seen
> any workable answers.
>
> Cheers
>
> Mick
Back to top
Login to vote
Wayne-I-M

External


Since: May 21, 2006
Posts: 2922



(Msg. 3) Posted: Sat Aug 30, 2008 10:57 am
Post subject: RE: GPS -> Access query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi

Bad news - cant be done. Sorry.
1st you would need to walk around with a laptop in your hand to be able to
autoupdate the access DB.
2nd There is no auto export from garmin and access can not create an
exportable file within the garmin layout

The extrex comes with the garmin programme (you need to register in line to
get the export facility). Best bet would be to store to the track log and
then save as CSV then use access to import the data. You can simply set up a
auto-import if you want.

Makes me think back - I used to teach garmin courses (back in the day, LoL)


Anyway - sorry but can't be done to track the track log - BUT - you can to
"non" track-log waypoints dont forget the even though when exported you get
the Lat and Longs of both with the track log waypoints they are no
independent - but other way points are which is why they could be exported).
But this still needs a good bit of skill with vba and to be able to create a
small dll to generate the csv. To me it would seem a waste of time but you
could create something - there may be a market for it - no one is doing this
at the moment.

Good luck

--
Wayne
Manchester, England.



"mick" wrote:

> Can I connect my etrex to a notebook and (in real-time) have the track log
> points saved into a table and displayed on a (continuous) form.
>
> Has anyone done this - I have seen some questions about this but not seen
> any workable answers.
>
> Cheers
>
> Mick
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Getting Started All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET