Using abcon in Access VBA

[HartwellTelecoms]

Hi Guys,

Im trying to use VBA within Access to connect to the call centre and control a Telset.

I have been trying to search forums and have asked the questions before however not really got anywhere.

What I have done so far:

obtained the abcon32.ocx from Aspect and in Visual Basic for Application I went to Tools>References and added it

Tried to register it register it via opening a form, Tools>ActiveX Controls however said said it could not be added/deleted. Install/remove the control using a separate setup utility.

Im stuck at what to put for the code,

Function connect()
Dim abcon As abconlib.abcon
abcon.Host = "127.0.0.1"
abcon.PortType = 1
abcon.Port = 7000
If (abcon.OpenConnection = 0) Then
MsgBox "Success"
Else
MsgBox "Failure"
End If
End Function

It says "Object variable or With block variable not set"

Im guessing im not setting abcon correctly, anyone got any ideas? Example code of what you or ready have would be great so I could copy n paste and it should work (had an example before but was missing all the things it referenced)

 

[arznrchrd]

Couple things here. First, you cannot just receive the abcon.ocx as a file and try to add it in Access. You have to install it using the Aspect contact server media install. And then select CMI Custom Control DEV. This adds the abcon.ocx dev control to your PC and also registers it (behind the scenes). Once this is done you can add it by the means you are trying.

However, a note about Access. I tried this years back with Access. I was able to connect to the call center, but Access is not and was unable to handle the asynchronous messaging that the CMI interface uses. Moving it to VB6 and now VB.NET is a way better approach and it works perfectly with no issues. Screen-pops, etc work great once you have it coded. But also you need to make sure your CCT's are setup properly to pass the CTI information.