?
Solved

Programatically make VOIP call using VB in Access

Posted on 2011-02-14
8
Medium Priority
?
1,222 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:AMPLECOMPUTERS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
8 Comments
 
LVL 85
ID: 34892406
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.
0
 

Author Comment

by:AMPLECOMPUTERS
ID: 34907083
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.
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 34907253
Then you'll have to examine the various VOIP solutions out there to determine if they provide that sort of automation. Command-line style interaction is governed by the program, and is not something that is forced by Windows. In other words, if you use Skype, for example, then the Skype.exe program would have to be written such that it would accept commandline parameters, or would have to provide you with some form of an API/SDK in order for you to automate. If the developers of Skype decided to NOT do this, then you're out of luck.

BTW, I'm a big fan of Skype, and in fact Skype offers an API:

http://developer.skype.com/accessories

I'm not sure you could do this within Access, however. In most cases, web-based applications like Skype require you to be able to consume WebServices, which requires a web-based application or a more advanced programming language (like VB.NET).
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:AMPLECOMPUTERS
ID: 35207925
I found that Skype can be called from the command line so I will work on that angle.
0
 
LVL 85
ID: 35447752
Seems like the author went with Skype, so my suggestion here 34907253 would qualify as the solution, it would seem.
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 35714971
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Introduction to Processes
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question