Board ArchivesSite FeaturesActiveworlds SupportHistoric Archives |
mulligan // User Search
mulligan // User SearchVBA and Grimm's OCXApr 27, 2000, 2:27pm
Has anyone had any luck utilising the OCX and Type Library under a VBA
environment such as Microsoft Access '97/2000? I use VBA and a number of ActiveX controls day-in day-out at work, but I'll be damned if I can get the SDK to work under Access '97. I have the wrapper registered as a control and included in my list of References. Rather than use the control on a form, I've declared an object variable of type AwSdkOcx and I'm working with that. However, my first call to AwCreate throws an illegal operation. My code works something like this - Dim SDK As AwSdkOcx ' local to the form class module Private Sub cmdLogin_Click() Dim rc As Integer Set SDK = Me!axSDK.Object ' make explicit reference to object property, unlike VB rc = SDK.AwInit(AW_BUILD) SDK.AwEventSet AW_EVENT_AVATAR_ADD rc = SDK.AwCreate("0", 0) ' this throws the illegal op Can anyone cast any light on what I'm doing wrong? My libs are all the correct versions as I've managed to write a few little apps in C++ quite happily. Thanks in advance. Mulligan. VBA and Grimm's OCXApr 27, 2000, 2:29pm
Apologies. This probably should have been posted to the sdk newsgroup.
SDK docsApr 21, 2000, 9:36am
My first post, so please forgive any indiscretions/stupidity.
Is there anywhere I can download the entire sdk documentation for offline browsing? Save me connecting and running up my phone bill any more than it is already. Cheers. Mulligan. -- "Any sufficiently advanced technology is indistinguishable from magic" (Arthur C. Clarke) "Reality is plural and mutable" (Robert Anton Wilson) "Do I look like a hippie with a violin?" (Justin Sullivan) MrGrimm's OCX and VBAApr 30, 2000, 7:05am
Has anyone had any luck utilising the OCX and Type Library under a VBA
environment such as Microsoft Access '97/2000? I use VBA and a number of ActiveX controls day-in day-out at work, but I'll be damned if I can get the SDK to work under Access '97. I have the wrapper registered as a control and included in my list of References. Rather than use the control on a form, I've declared an object variable of type AwSdkOcx and I'm working with that. However, my first call to AwCreate throws an illegal operation. My code works something like this - Dim SDK As AwSdkOcx ' local to the form class module Private Sub cmdLogin_Click() Dim rc As Integer Set SDK = Me!axSDK.Object ' make explicit reference to object property, unlike VB rc = SDK.AwInit(AW_BUILD) SDK.AwEventSet AW_EVENT_AVATAR_ADD rc = SDK.AwCreate("0", 0) ' this throws the illegal op Can anyone cast any light on what I'm doing wrong? My libs are all the correct versions as I've managed to write a few little apps in C++ quite happily. Thanks in advance. Mulligan. |