Click To Call using SIP RRS feed

  • 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


    Friday, June 8, 2018 6:47 PM

All replies

  • 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...

    Friday, June 8, 2018 6:54 PM
  • 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,


    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 MSDNFSF@microsoft.com.

    Monday, June 11, 2018 8:30 AM