Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Tue Nov 2 15:12:48 CST 2004
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