Link to home
Start Free TrialLog in
Avatar of AMPLECOMPUTERS
AMPLECOMPUTERS

asked on

Programatically make VOIP call using VB in Access

We have an existing database that is a MySQL backend and an Access front end. It has served us well for many years. We are now extending this to include touchscreen monitors and linking the database to a couple of web applications. One function I would like to have is to use the touchscreen to click on a client, then click on a "call" button. This should be able to use some kind of command-line call from VB in Access to launch or control some VOIP app to place a call (the monitor will have speakers and I can mount a mic on top of the monitor).

I suppose what I need is suggestions for a VOIP app/service/software that can place a call over the internet to a mobile or landline that can be controlled, or at least can be directed to place a call from the VB in Access. Of course free would be great! But I highly doubt that is going to happen so lets say it needs to be reasonably affordable.

If you also happen to have examples of calling that app from VB that would be a bonus!
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

The first thing you'd need to do would be to settle on a VOIP solutions, since that solution may have a builtin utility to allow you to call into it.

Barring that, you can always make use of the TAPI features of Windows to manage this. This is a massive subject; here's the starting point:

http://msdn.microsoft.com/en-us/library/ms734273(v=vs.85).aspx

VB classic has a control you could use, if I'm not mistaken. And .NET seems to be much more tightly integrated with this as well. Access will be a tough nut to crack with the TAPI stuff, I'd bet.
Avatar of AMPLECOMPUTERS
AMPLECOMPUTERS

ASKER

Therein lies the problem, I can not settle on a VOIP solution unless that solution provides the capabilities I need.

I think this may be a little over the top. I was thinking more along the lines of a command line parameter or something. For example:

Dim CustNumber as String
Dim DialString as String
CustNumber=Me!txtCustNumber
DialString = "voipapp.exe /dial" & CustNumber
Call DialString
msgbox("Placing call...")
Call "voipapp.exe /close"

This would get the phone number from the form on the screen and pass it in the call statement to the executable of the VOIP calling app. Then it would pop up a box telling me that it is connecting, then once I click OK on the messagebox it would close the VOIP app.

Now I am not dead set on command line parameters, but I am looking for a simple solution that requires a minimum of programming. All I need to be able to do is place a call to a particular number and disconnect.

I suppose I should also clarify something. I am looking for a single line solution, not a multiline business service, I need no incomming line or number, no voicemail, no frills. I would prefer a solution that would allow unlimited calls in the US for a flat monthly fee. This would strictly be so that an employee could be at a service terminal, click on a "call" button and be connected to a client using an internet phone service (VOIP) speaking through a microphone mounted on the front of the monitor.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I found that Skype can be called from the command line so I will work on that angle.
Seems like the author went with Skype, so my suggestion here 34907253 would qualify as the solution, it would seem.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.