Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Developers    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Make a Phone Call
Mark Hinerman 
   
4 years ago
I need to be able to make phone calls "directly" from Access database where the phone number has been stored.  I can do it easily in EXCEL but have not been able to find any information regarding how to do it on Access.  I have phone numbers stored with other Customer info and when I pull up a specific record, I can see the phone number and I need to be able to click on a button beside it and have it dial the number so I don't have to enter it again.  THANKS SO MUCH IN ADVANCE FOR ANY HELP.
Kevin Robertson  @Reply  
          
4 years ago
If you have a modem installed the Command Button wizard has an Auto Dialler option under Miscellaneous.
Or in VBA code:

On Error Resume Next
DoCmd.GoToControl "Phone"
DoCmd.RunCommand acCmdAutoDial
Alex Hedley  @Reply  
           
4 years ago
Mark Hinerman OP  @Reply  
   
4 years ago
Thanks for the "AutoDial" info.  I got that to work, but I don't know how to load a field from the Records so when I click on a button it will dial the phone number that is in the field.  If I can find a way to load the number from a field that holds the phone number and then have it autodial it.... that will work.  Obviously I don't know anything about coding in ACCESS.  I would be willing to pay a little if some one could give me further instructions to do what I need to do.  THANKS FOR  YOUR HELP KEVIN... just need more info on how to auto load the phone number from a selected record that has the phone number stored in a field.
Kevin Robertson  @Reply  
          
4 years ago
Mark,

Right click on the button and click 'Build Event'. This will open the macro for the button.
Enter the name of your phone number field where it say 'Go To Control'.
Kevin Robertson  @Reply  
          
4 years ago

Richard Rost  @Reply  
          
4 years ago
I was chatting with Mark about this in email. I haven't used the Autodialer since... geez... 2002 or 2003? LOL. It would be nice if there was a way to integrate with a VoIP solution or something like Google Voice. Mark is the only person in 20 years to ask me about this though.
Alex Hedley  @Reply  
           
4 years ago
https://developers.google.com/voice-actions
Richard Rost  @Reply  
          
4 years ago
I don't think that's it. I'm looking for an API for VBA to connect a call thru Google Voice via the Web Browser.
Alex Hedley  @Reply  
           
4 years ago
Could convert some Python
https://code.google.com/archive/p/pygooglevoice/

https://github.com/pettazz/pygooglevoice

https://github.com/jaraco/googlevoice
Richard Rost  @Reply  
          
4 years ago
Too much effort. LOL
Alex Hedley  @Reply  
           
4 years ago
Richard Rost  @Reply  
          
4 years ago
Sure. Knock yourself out. :)
Mark Hinerman OP  @Reply  
   
4 years ago
Kevin, I sincerely appreciate the information you have provided.  However, please understand that I am using Access to try and accomplish a very limited task... and as much as I would actually like and enjoy learning Access... I DO NOT have the time to do so at this point.  I did a lot of programming... but that's over 30 years ago and needless to say nothing is applicable today.  I do not mind paying you if you can afford me the total answer as in from start to finish as each section of "code" is not helping me unless I can find the time to fully understand the programming language used here... and again... I CANNOT invest the time now.  What I'm asking is to provide me the full lines of code from start to finish and you assume I know nothing... which is true about Access.  You can use any field name from a database as an example and even an Access idiot like me can understand where and how to switch the field name and file name.  Again, I sincerely appreciate your efforts.
Kevin Yip  @Reply  
     
4 years ago
Mark, have you tried the "tel" protocol?  It brings up the default phone app on whatever device and platform you are on.  If you don't have a default phone app, you will be prompted to choose on.  The Access VBA command is one line.  If your phone number is in a text box named PhoneNum, then create a command button whose OnClick event will run this:

Application.FollowHyperlink "tel://" & PhoneNum

In Excel, it works the same way.  The function below dials the number in cell C3:

=HYPERLINK("tel://" & C3, "Dial Me!")
Mark Hinerman OP  @Reply  
   
4 years ago
Kevin..... THANK YOU THANK YOU THANK YOU.
Eduardo Benaim  @Reply  
     
4 years ago
Mark:  I use Ring Central as my Phone Dialer System.  I call people every day from the Access Database.   All I do is to Highlight the Phone and Press {F6}. ring Central takes Over nicely.  I built some code to do this in a double click function.
First you must LAunch the RingCentral (Once) C:\........\RingCentral\SoftPhoneApp\Softphone.exe then you can use a Macro or code such as SendKeys {F6}.  I hope it Helps

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/7/2026 11:58:22 PM. PLT: 1s