Thanks for update! Here one more link on this tech...

2008-04-04T13:05:00.000+04:00

Thanks for update! Here one more link on this technique from FMS:
http://www.fmsinc.com/free/newtips/access/accesstip1.asp

Hi Alex,I think there is some other general logic....

2008-04-04T04:30:00.000+04:00

Hi Alex,

I think there is some other general logic.
While we're embedding some ActiveX on form, access creates UserControl object, that contains our ActiceX one.
Very similar to embedding Form Object in Subform Control ...
(Note that SubformControl has different properties and events then Form Object ;-)

So we can see the events defined only for that common "usercontrol" and not for exact object we just embedded in it (ActiveX).

The way you have suggested is right.

But sometimes we need something else.
For example let's embed TreeView control (CommonControl ActiveX).

While we want IntelliSense in VBE we should make something like this:

'form/class module level declaration:
Dim WithEvents tv1 as TreeView
' ^^^^^^^^^^

Private Sub Form_Open(...)
Set tv1 = Me.MyTreeViewCOntrol1.Object
' ^^^^^^
End Sub

and now, in any procedure body in that form module (class module), we can get VBE IntelliSense while calling tv properties and methods (just typing dot after variable) or event procedures (by choosing right one in top-rigth combo, as you're suggesting)

king regards
KN

Comments on Alex & Access: ActiveX control events

Thanks for update! Here one more link on this tech...

Hi Alex,I think there is some other general logic....