handyman at actcom.co.il
handyman at actcom.co.il
Tue Nov 2 21:12:50 CST 2004
I use a dsl line, but have a separate modem for the phone line. I tried out the callaudit program from Mountain Systems, and it seems to have all the features I need. I just have to work on integrating it with my appliaction. I would have preferred to put this straight into my application, but why reinvent the wheel :) Thanks gm At 10:12 PM, 11/2/2004 +0100, you wrote: >If you have ISDN you gonna need a ISDN card with CAPI support. >There is some VB code out there to use CAPI in access. >I have such an Access DB that use a CAPI control for wich the VB code >was available. > >Dont know the website anymore, it was several years ago. > >This only works with ISDN and a CAPI supported card like Eicon > >Erwin > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >handyman at actcom.co.il >Sent: Tuesday, November 02, 2004 6:08 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Caller ID and Access > >Thanks! > >This program from Mountain Systems seems to do a lot of the stuff I >want. >Since it stores all information in an Access database, I can just >integrate it with my database with some work. > >Thanks again! > >gm > > At 11:00 AM, 11/1/2004 -0800, you wrote: > > From a few years back > >You will have to use TAPI, your modem need's to support caller ID Ughh, > > >you are in Italy so you may have to check the format of caller id North > > >America had half a dozen standards from the various Telco's in Mid 90's > > >It was a mess. > >It is essentially about 55 bytes of data being sent between the first > >and second ring of the phone It can be more data, there are a couple > >of formats some included the callers name and blocking info in addition > > >to the number. > >I can't remember if there is now an established ISO standard I did this > > >back in 99. > > > >What I would do is try the trial version of Mountain Sys on your > >telephone system and modem It is only $15 a client, but you could roll > >your own code via Tapi after getting a format from your Telco but maybe > > >they have standardized format by now in Italy. > > > > Companies that seem to handle callerid connections to Access. > > > > Mountain Systems http://www.mtnsys.com > > > > CallAudit Software has sample Access 97 & 95 database with > > trial software that connects thru DDE. > > > > There are a lot of others. > > -------------------------------------------------------------------- > > From Mountain System FAQ buried in there > > > >How to Test a MODEM for Caller ID Support Caveats. > > > >Necessary equipment > > > > * Caller ID Service From your local telephone company > > * A Voice MODEM or hardware device that supports Caller ID > > > > > > Just about every MODEM disables Caller ID as the default. > > > > For most MODEMs, the string AT#CID=1 or AT#CLS=8#CID=1 will enable > > Caller ID. > > If Caller ID is not working, you will only see the word RING for > > each incoming ring. > > > > The most common result, when Caller ID data works, is the following: > > > > RING > > > > DATE = xxxxx > > > > TIME = xxxx > > > > NMBR = xxxxxxxxx > > > > NAME = xxxxxxxx > > > > RING > > > > RING … > > > > There are other formats as well. The key point is that other data > > generally appears between the first and second rings. > > > > Some telephone companies, especially in Canada, ship Caller ID data >in > > different formats, Check the software handles this. > > > > TAPI support for Caller ID was added after Windows 95 was released. > > Microsoft has an updated version of UniModemV on their Web page that > > > includes Caller ID support. The .INF file for your MODEM also needs to > > > modified to take advantage of this support, and some modems do not > > yet have this capability. > > > > Windows NT 3.X does not include any support for TAPI. Although > >Windows > > NT 4.0 does. > >handyman at actcom.co.il wrote: > > > >>Hi, > >> > >>I'm interested in somehow retrieving a CallerID number from my modem, > >>and then displaying the caller's information(taken from my database) > >>on screen. Has anyone ever done anything like this, or can point me > >>in the right direction > >> > >>Thanks, > >> > >>Gershon Markowitz > >>mailto:Handyman at actcom.co.il > > > >-- > >Marty Connelly > >Victoria, B.C. > >Canada > > > > > > > >-- > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > >Gershon Markowitz >mailto:Handyman at actcom.co.il >http://www.yadchaimtzvi.org >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com Gershon Markowitz mailto:Handyman at actcom.co.il http://www.yadchaimtzvi.org