Results 1 to 12 of 12
  1. #1
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8

    Controlling VOIP softphones

    Hi



    Can Access interact with VOIP software to initiate calls from within the database?

    I'm looking at zoiper or x-lite software. I have installed zoiper and have access to the vba code library for it, but I can't make it do anything. I've searched the web but can't find any useful information about it.

    Any help would be greatly appreciated.

    Matt

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Quote Originally Posted by matt_t View Post
    Hi

    I have installed zoiper and have access to the vba code library for it, but I can't make it do anything.

    So this product has its own reference library for vba, and you can't get it to work? Mind putting some code up?

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    are you using 64bit access? - it may be that the code provided by zoiper will only run on 32bit.

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Skype has some really nice API's to do stuff like this using Skype.

  5. #5
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    Quote Originally Posted by redbull View Post
    So this product has its own reference library for vba, and you can't get it to work? Mind putting some code up?
    Yes, I can see the objects in object browser, but don't really know where to start with them. Here's what I'm trying:

    Code:
    Private Sub cmdZoiper_Click()
    On Error GoTo Err_cmdZoiper_Click
    
    
        Dim Zoi As ZoiperAPI.IZoiperCall
        
        MsgBox Zoi.Version
        
        Set Zoi = Nothing
        
    Exit_cmdZoiper_Click:
        Exit Sub
    Err_cmdZoiper_Click:
        MsgBox Err.Description
        Resume Exit_cmdZoiper_Click
    End Sub
    It compiles, but when I run it I get the error 'Object variable or With block variable not set'. I seem to get this message every time I try to run anything. I'm a bit out of my depth here, I haven't tried to use non-microsoft code libraries before.

    Thanks for your help
    Matt

  6. #6
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    Quote Originally Posted by Ajax View Post
    are you using 64bit access? - it may be that the code provided by zoiper will only run on 32bit.
    No, it's 32 bit Access.

  7. #7
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    Quote Originally Posted by Perceptus View Post
    Skype has some really nice API's to do stuff like this using Skype.
    Thanks, but my remit is to integrate with either zoiper or x-lite, preferably zoiper.

  8. #8
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    The problem with your code is you are not setting Zoi to be anything (other than nothing at the end)

    Would expect something like

    Set Zoi = new ZoiperAPI.something

    can you post a list of the objects and functions

  9. #9
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    Quote Originally Posted by Ajax View Post
    The problem with your code is you are not setting Zoi to be anything (other than nothing at the end)

    Would expect something like

    Set Zoi = new ZoiperAPI.something

    can you post a list of the objects and functions
    Thanks Ajax, I did try

    Set Zoi = New ZoiperAPI.IZoiperCall

    but it doesn't compile, with the error 'Compile error: Invalid use of New keyword'

    Is there a way of exporting the objects from object browser, or shall I post a screenshot of it?

  10. #10
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    I've attached a screenshot. Couldn't get the whole screen in, hence the scroll bars.
    Matt
    Attached Thumbnails Attached Thumbnails zoiper.JPG  

  11. #11
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    It was just a guess but you need to instantiate an instance. I don't think I can really help - I found this link

    http://www.zoiper.com/downloads/Zoip...umentation.pdf

    which opens a pdf. It is for web apps, but you can see the general functions which you should be able to translate to vba and there is plenty of documentation about how it all works, you just need to read it - there is also a link to their support email at the bottom - perhaps they can help.

  12. #12
    matt_t is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    8
    Quote Originally Posted by Ajax View Post
    It was just a guess but you need to instantiate an instance. I don't think I can really help - I found this link

    http://www.zoiper.com/downloads/Zoip...umentation.pdf

    which opens a pdf. It is for web apps, but you can see the general functions which you should be able to translate to vba and there is plenty of documentation about how it all works, you just need to read it - there is also a link to their support email at the bottom - perhaps they can help.
    I had found an older version of the web api documentation, and found it confusing as it referred to classes that don't exist in the vba library. However, I've just found the com api documentation on their website and think I've cracked it now. I can at least get it to tell me what version it is, so it should be plain sailing from here.

    Thank you very much for your assistance.
    Matt

Please reply to this thread with any new information or opinions.

Similar Threads

  1. subform controlling
    By Esmatullaharifi in forum Forms
    Replies: 2
    Last Post: 03-24-2015, 02:29 AM
  2. Controlling PDFs
    By Rob.Hill in forum Access
    Replies: 3
    Last Post: 07-14-2014, 01:04 PM
  3. Controlling subform resize
    By Deutz in forum Forms
    Replies: 2
    Last Post: 10-13-2011, 07:35 PM
  4. Controlling autonumber
    By Patience in forum Access
    Replies: 3
    Last Post: 06-22-2010, 04:11 AM
  5. Checkbox controlling text box
    By chuckduarte in forum Forms
    Replies: 0
    Last Post: 10-21-2008, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums