MSCOMCTL.OCX ListView Can't get click on Column Headers to work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrad - 20 Mar 2006 14:52 GMT

Hi,
I've not be able to get the column header click event to work when
adding
the ActiveX control Listview as contained in MSCOMCTL.OCX.
It fails to compile with the error message, "Procedure declaration
does not match..." and the normal workround of using
MSComctlLib.ColumnHeader, does seem to work either.

Has anyone used the Listview and Treviews from this OCX in Access (XP
and
2003)?
Can you post a working solution?

Private Sub lvwDB_ColumnClick(ByVal columnheader As
MSComctlLib.ColumnHeaders)
MsgBox ("Click")
End Sub

Thanks
John

Reply to this Message

Alex Dybenko - 20 Mar 2006 18:06 GMT

Hi,
delete this event declaration, and add new one by selecting listview name in
class module top left combo, and then select event name in right combo. both
comboboxes are on the top of form's class module window

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi,
> I've not be able to get the column header click event to work when
[quoted text clipped - 16 lines]
> Thanks
> John

Reply to this Message

jrad - 21 Mar 2006 00:52 GMT

Hi,
Many, many thanks.
The crucial bit is the formal parameter's type of Object
Private Sub lvwDB_ColumnClick(ByVal ColumnHeader As Object)

I had found a workround by using WithEvents on a module variable, and
now I see why that worked, as it was of type Object.

Thanks again.
John

Reply to this Message