Listview runtime.. not working

[Kiran2012]

Hi,

I created a form (VBA + Access) which have 2-3 Listview controls. This tool will be shared to my whole team. Listview ref is missing in many of the user's systems. I got a couple of codes to add listview ctrl on runtime. But this is not working. Kindly review the below code and help me to sort this out. Thanks in advance.

Please Login or Register  to view this content.

Also:-

Please Login or Register  to view this content.

[OllieB]

Kiran,

you may want to elaborate a bit on "But this is not working". Error message or problem?

[Kiran2012]

Hi,

The first set of code (AddListViewControl) doesn't throw any errors. Second set of code results in a 'Type mismatch' error on line 'Set ctl = .Controls.Add("MSComctlLib.ListViewCtrl.2", "ListView1")'
Is there any non ocx listview cntrl that i can use?

[OllieB]

Hi Kiran,

Please declare ctl as a ListView type of object, or use the generic "object" type if you want to use late binding

[Kiran2012]

Hi,

Thanks you!! Its working...