Click To Call using SIP

Question

I have a client that uses the Click to Call very regularly. They have a table with a hyperlink field. In the past they have been able to right click and go to Edit Hyperlink and put in sip:9999999999. But I have had to disable their shortcut menus and they don't have that option any longer.  I've tried putting in visual basic code after they enter the phone number (phone number doesn't have any "-" or "()") but it isn't working. Here's what I'm doing:

Dim m1, m2, m3, m As Variant

If IsNull(Me.Cell_Phone.Value) = False Then

    m1 = Left(Me.Cell_Phone.Value, 3)

    m2 = mid$(Me.Cell_Phone.Value, 4, 3)

    m3 = Right(Me.Cell_Phone.Value, 4)

    m = m1 & "-" & m2 & "-" & m3

    Me.Click_To_Call = m & "#" & "sip:" & Me.Cell_Phone.Value & "#"

The hyperlink appears as 999-999-9999

It looks like it should but when you click on it, it just goes to a url

When it puts the data in the field and I go to manually edit the table it puts in http://999-999-9999

Thanks

Answer 1

Hi,

I am not familiar with Click to Call (is it an app?) or the SIP protocol but I was just wondering if the default app or the associated app to the SIP protocol was somehow got changed and assigned to the browser.

Just my 2 cents...

Answer 2

Hello Arkansas Lady,

As far as I know, MS Access does not support Click-To-Call function and I'm wondering how do you implement this function in Access. What's the Me.Click_To_Call?

Besides,  is below link helpful for your issue?

Access click to call 

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].