PDA - comp.databases.ms-access

As far as I know, there's no version of Access that runs on any PDA or phone operating system (not even Windows CE). For good information on effective use of newsgroups, see http://www.mvps.org/access/netiquette.htm -- you'll see that newsgroups are good sources of answers for specific questions. Do you have a question? -- Larry Linson, Microsoft Office Access MVP Co-author: "Microsoft Access Small Business Solutions", published by Wiley Access newsgroup support is alive and well in USENET comp.databases.ms-access "ngs" <bsnbsn_SNABELA_ofir.dk> wrote in message news:4cf38928$0$56785$edfadb0f@dtext02.news.tele.dk... > Hello NG > > Somebody with experience in Access on PDA... > > Bjarne >

Sorry Larry - yes I have a question... I have no experience in PDA�s... 1 - Can i get a result of a query to show on a PDA...??? 2 - Can Access send a message to a PDA...??? Bjarne "Access Developer" <accdevel@gmail.com> skrev i en meddelelse news:8lii3tFa1mU1@mid.individual.net... > As far as I know, there's no version of Access that runs on any PDA or > phone operating system (not even Windows CE). For good information on > effective use of newsgroups, see > http://www.mvps.org/access/netiquette.htm -- you'll see that newsgroups > are good sources of answers for specific questions. Do you have a > question? > > -- > Larry Linson, Microsoft Office Access MVP > Co-author: "Microsoft Access Small Business Solutions", published by Wiley > Access newsgroup support is alive and well in USENET > comp.databases.ms-access > > > > "ngs" <bsnbsn_SNABELA_ofir.dk> wrote in message > news:4cf38928$0$56785$edfadb0f@dtext02.news.tele.dk... >> Hello NG >> >> Somebody with experience in Access on PDA... >> >> Bjarne >> > >

Per ngs: >Somebody with experience in Access on PDA... At one time, at least, there was a non-access product for Palm Pilot that somehow interfaced with an MS Access DB on a PC. Lacking Access on a PDA, a last-ditch fallback position might be Remote-Desktopping into a PC that is running Access. Dunno from the official RemoteDesktop app, but something called TeamViewer does the job for letting my iTouch open up a screen on one of my XP boxes. Problem is scaling and screen size. The little PDA screen makes it awfully tedious to do anything - although I guess an MS Access app could be written with forms designed with a PDA screen in mind. -- PeteCresswell

Access VBA provides extensive ability to use the Windows APIs. You can send e-mail via Access, dial telephone calls, and you can send other kinds of messages by using the Windows APIs. I am not familiar with the message protocols for PDAs and phones, but the probability is high that you can send information from Access to a PDA. I'm sure that it will take detailed knowledge of the messaging protocols of the PDA, how to use Windows to send such messages, and the internal workings of that device, especially if you want to be able to scroll through many records returned by a query. As Pete mentioned, there was software that interfaced with Access from such devices, so that would demonstrate that it could be done with the software of the time -- and my guess is that it can be done with software of our time, too. I don't know how many thousands of "false leads" you might get, but using Bing and/or Google to search for "Microsoft Access" _and "communicate with PDA" or "communicate with cellphone" might be a start at getting some details. Larry Linson, Microsoft Office Access MVP "bsn" <bsnSNABELAoncableDOTdk> wrote in message news:4cf43095$0$56795$edfadb0f@dtext02.news.tele.dk... > Sorry Larry - yes I have a question... > > I have no experience in PDA�s... > > 1 - Can i get a result of a query to show on a PDA...??? > 2 - Can Access send a message to a PDA...??? > > Bjarne > > > "Access Developer" <accdevel@gmail.com> skrev i en meddelelse > news:8lii3tFa1mU1@mid.individual.net... >> As far as I know, there's no version of Access that runs on any PDA or >> phone operating system (not even Windows CE). For good information on >> effective use of newsgroups, see >> http://www.mvps.org/access/netiquette.htm -- you'll see that newsgroups >> are good sources of answers for specific questions. Do you have a >> question? >> >> -- >> Larry Linson, Microsoft Office Access MVP >> Co-author: "Microsoft Access Small Business Solutions", published by >> Wiley >> Access newsgroup support is alive and well in USENET >> comp.databases.ms-access >> >> >> >> "ngs" <bsnbsn_SNABELA_ofir.dk> wrote in message >> news:4cf38928$0$56785$edfadb0f@dtext02.news.tele.dk... >>> Hello NG >>> >>> Somebody with experience in Access on PDA... >>> >>> Bjarne >>> >> >> > >

On Tue, 30 Nov 2010 10:21:08 -0500, "(PeteCresswell)" <x@y.Invalid> wrote: >>Somebody with experience in Access on PDA... > >At one time, at least, there was a non-access product for Palm >Pilot that somehow interfaced with an MS Access DB on a PC. Handbase was one simple such system. Pendragon I think another but it was a complete programming environment. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/

Thx Larry I�ll try look into it... Bjarne "Access Developer" <accdevel@gmail.com> skrev i en meddelelse news:8ll2d8Fl65U1@mid.individual.net... > Access VBA provides extensive ability to use the Windows APIs. You can > send e-mail via Access, dial telephone calls, and you can send other kinds > of messages by using the Windows APIs. I am not familiar with the message > protocols for PDAs and phones, but the probability is high that you can > send information from Access to a PDA. I'm sure that it will take > detailed knowledge of the messaging protocols of the PDA, how to use > Windows to send such messages, and the internal workings of that device, > especially if you want to be able to scroll through many records returned > by a query. > > As Pete mentioned, there was software that interfaced with Access from > such devices, so that would demonstrate that it could be done with the > software of the time -- and my guess is that it can be done with software > of our time, too. > > I don't know how many thousands of "false leads" you might get, but using > Bing and/or Google to search for "Microsoft Access" _and "communicate with > PDA" or "communicate with cellphone" might be a start at getting some > details. > > Larry Linson, Microsoft Office Access MVP > > "bsn" <bsnSNABELAoncableDOTdk> wrote in message > news:4cf43095$0$56795$edfadb0f@dtext02.news.tele.dk... >> Sorry Larry - yes I have a question... >> >> I have no experience in PDA�s... >> >> 1 - Can i get a result of a query to show on a PDA...??? >> 2 - Can Access send a message to a PDA...??? >> >> Bjarne >> >> >> "Access Developer" <accdevel@gmail.com> skrev i en meddelelse >> news:8lii3tFa1mU1@mid.individual.net... >>> As far as I know, there's no version of Access that runs on any PDA or >>> phone operating system (not even Windows CE). For good information on >>> effective use of newsgroups, see >>> http://www.mvps.org/access/netiquette.htm -- you'll see that newsgroups >>> are good sources of answers for specific questions. Do you have a >>> question? >>> >>> -- >>> Larry Linson, Microsoft Office Access MVP >>> Co-author: "Microsoft Access Small Business Solutions", published by >>> Wiley >>> Access newsgroup support is alive and well in USENET >>> comp.databases.ms-access >>> >>> >>> >>> "ngs" <bsnbsn_SNABELA_ofir.dk> wrote in message >>> news:4cf38928$0$56785$edfadb0f@dtext02.news.tele.dk... >>>> Hello NG >>>> >>>> Somebody with experience in Access on PDA... >>>> >>>> Bjarne >>>> >>> >>> >> >> > >

Yeah thats the problem - small screens... My problem is: A man in a car should receive a message from home(Access) on his PDA, when some new job comes up on the same day he is out driving... Its just few lines on the small screen... Bjarne "(PeteCresswell)" <x@y.Invalid> skrev i en meddelelse news:ac5af6h55iljs8n34bt1i8qlkp6a73v2sn@4ax.com... > Per ngs: >>Somebody with experience in Access on PDA... > > At one time, at least, there was a non-access product for Palm > Pilot that somehow interfaced with an MS Access DB on a PC. > > Lacking Access on a PDA, a last-ditch fallback position might be > Remote-Desktopping into a PC that is running Access. > > Dunno from the official RemoteDesktop app, but something called > TeamViewer does the job for letting my iTouch open up a screen on > one of my XP boxes. > > Problem is scaling and screen size. The little PDA screen makes > it awfully tedious to do anything - although I guess an MS Access > app could be written with forms designed with a PDA screen in > mind. > -- > PeteCresswell

Thx... See answer to Pete... Bjarne "Tony Toews" <ttoews@telusplanet.net> skrev i en meddelelse news:do3bf6ppobnamsvi5kb9ah5rlg2tml63ba@4ax.com... > On Tue, 30 Nov 2010 10:21:08 -0500, "(PeteCresswell)" <x@y.Invalid> > wrote: > >>>Somebody with experience in Access on PDA... >> >>At one time, at least, there was a non-access product for Palm >>Pilot that somehow interfaced with an MS Access DB on a PC. > > Handbase was one simple such system. Pendragon I think another but it > was a complete programming environment. > > Tony > -- > Tony Toews, Microsoft Access MVP > Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ > For a convenient utility to keep your users FEs and other files > updated see http://www.autofeupdater.com/

Per ngs: >Yeah thats the problem - small screens... > >My problem is: >A man in a car should receive a message from home(Access) on his PDA, when >some new job comes up on the same day he is out driving... > >Its just few lines on the small screen... Sounds like an 80% solution might be feasible using out-of-the-box resources. To wit, sending an eMail from an MS Access app is pretty straightforward. I would even hope to find an instant messaging API in Windows. On the other end, the user would have either an email app that checks for mail periodically (and, hopefully, has a filtering capability so only selected messages get accepted) or an SMS app that the Access app would send to. -- PeteCresswell

"(PeteCresswell)" <x@y.Invalid> wrote in message news:kvrcf6hil8p1sfhokm1997mni2omt8d61o@4ax.com... > Per ngs: >>Yeah thats the problem - small screens... >> >>My problem is: >>A man in a car should receive a message from home(Access) on his PDA, >>when >>some new job comes up on the same day he is out driving... >> >>Its just few lines on the small screen... > > Sounds like an 80% solution might be feasible using > out-of-the-box resources. > > To wit, sending an eMail from an MS Access app is pretty > straightforward. I would even hope to find an instant messaging > API in Windows. > > On the other end, the user would have either an email app that > checks for mail periodically (and, hopefully, has a filtering > capability so only selected messages get accepted) or an SMS app > that the Access app would send to. > -- > PeteCresswell Or send the email to a cell phone instead of the PDA if that's feasable? Then the user gets immediate notification of the incoming txt msg (or email depending on the service) without needing to interface with the PDA at all. -- Clif McIrvin (clare reads his mail with moe, nomail feeds the bit bucket :-)

"Clif McIrvin" <clare.nomail@gmail.com> skrev i en meddelelse news:id69kp$6p7$1@news.eternal-september.org... > "(PeteCresswell)" <x@y.Invalid> wrote in message > news:kvrcf6hil8p1sfhokm1997mni2omt8d61o@4ax.com... >> Per ngs: >>>Yeah thats the problem - small screens... >>> >>>My problem is: >>>A man in a car should receive a message from home(Access) on his PDA, >>>when >>>some new job comes up on the same day he is out driving... >>> >>>Its just few lines on the small screen... >> >> Sounds like an 80% solution might be feasible using >> out-of-the-box resources. >> >> To wit, sending an eMail from an MS Access app is pretty >> straightforward. I would even hope to find an instant messaging >> API in Windows. >> >> On the other end, the user would have either an email app that >> checks for mail periodically (and, hopefully, has a filtering >> capability so only selected messages get accepted) or an SMS app >> that the Access app would send to. >> -- >> PeteCresswell > > > Or send the email to a cell phone instead of the PDA if that's feasable? > Then the user gets immediate notification of the incoming txt msg (or > email depending on the service) without needing to interface with the PDA > at all. I think its gonna be an SMS. Thx for input. Bjarne

"(PeteCresswell)" <x@y.Invalid> skrev i en meddelelse news:kvrcf6hil8p1sfhokm1997mni2omt8d61o@4ax.com... > Per ngs: >>Yeah thats the problem - small screens... >> >>My problem is: >>A man in a car should receive a message from home(Access) on his PDA, when >>some new job comes up on the same day he is out driving... >> >>Its just few lines on the small screen... > > Sounds like an 80% solution might be feasible using > out-of-the-box resources. > > To wit, sending an eMail from an MS Access app is pretty > straightforward. I would even hope to find an instant messaging > API in Windows. > > On the other end, the user would have either an email app that > checks for mail periodically (and, hopefully, has a filtering > capability so only selected messages get accepted) or an SMS app > that the Access app would send to. Thx for input. See answer to Clif... Bjarne

It can take a while, but ill come back with my result... Bjarne "(PeteCresswell)" <x@y.Invalid> skrev i en meddelelse news:1mnff6tdu0ic027voaclvup0huug5coa02@4ax.com... > Per bsn: >>I think its gonna be an SMS. >>Thx for input. > > After all the dust settles, how about letting us know what you > finally did and how well it worked? > -- > PeteCresswell