activeX control

[mvrp350]

Hi,

I've written an activex control. It's working fine on VB6. I'm also able to use it in word or excell.
If I want to use the activeX in access I'm not able to import it on my form. What might be causing this problem.

Any help is very much appreciated.

 

[The_Doc_Man]

Access requires two steps. On newer versions of Windows, THREE steps.

1. You must REFERENCE the control. On a code window (open module), follow path Tools >> References and add a reference to the .DLL

2. You must REGISTER the control. Same window, under tools, there is a Register ActiveX Control in the dropdown, separate from References.

3. On newer versions of Windows, you MIGHT have to find a way to digitally sign and then TRUST the ActiveX control, particularly if you have WinXP SP2 in place. But ever since Win2K, certain things have had digital signature options that could be REQUIRE depending on system security settings. WinXP SP2 is known to set system security to required signed modules.

 

[mvrp350]

Doc_Man,

I might be mistaken, but referencing in access (XP btw) has to be done using activeX-> register, and that can only be done in the design-view of the form, not in the coding-window.
If I'm wrong please correct me, but I haven't found a referencing option in the coding window.

I'll take a look at the digital signing, that might be a hint in the right direction. Thanks mvrp350