I have a list of contacts in an Access database table. How
can I dial the phone numbers I have stored there? I have a
modem in the PC, and would also need a way to put some
code behind a button labeled "Hang Up", so that once the
party answered, the modem would release the line. I don't
mind coding the API and something based on RAS might work
but I don't know where to begin dealing with RAS.
Thanks.
Hi Tim,
Access has had an Autodial facility for years; look in help for "Add a
button to dial a selected phone number" or some such.
>I have a list of contacts in an Access database table. How
>can I dial the phone numbers I have stored there? I have a
[quoted text clipped - 5 lines]
>
>Thanks.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
TimH - 19 Jan 2005 22:56 GMT
All this time and I never noticed this. I looked at the code and
apparently there is a little built in application for dialing numbers!
To get it to work, you have to place the cursor in the field where the
phone number is, and then click on the button. The little app
apparently grabs the number off the screen and waits for you to approve
it. I could program a button of my own and call this app this way:
Dim sPhoneNumber as String
me.whateverfieldthenumberisin.SetFocus
sPhoneNumber = Me.whateverfieldthenumberisin.text
application.run "utility.wlib_AutoDial", sPhoneNumber
and i borrowed the phone art.
Why do I need that SetFocus? without it I get an error message, run
time error 2185, can't reference a property or method of a control
unless it has the focus.
Thanks,
Tim