Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to access listview events in VBA? 1

Status
Not open for further replies.

SeanR01

MIS
Jan 22, 2002
29
AU
Hi all,

If I drop a MS Listview 6.0 control onto an Access form, I can populate it with a recordset, but I can't access any other events with it -- the default events on the form are only 'after update' and entry and exit/focus events. Are many VB6 ActiveX controls essentially unusable in VBA in this fashion? Or can anyone indicate how to 'liven up' the availability of the full set of events? Or am I missing something

Thanks,
Sean
 
I tried that, but the compiler just rejected the Subs as invalid -- don't remember the error message -- something about event not being availalble or what have you.

Have you found that typing them in works? How do you get around the compiler error? And how do you get to know what the event names actually are if they are not accessible?
 
I don't get a compile error. At the top of the code window you should see a box with (General) in it. Select the name of your listview control in this box. There is a box to the right, select the event you want from this box.
 
ah, well done, that's got me going without any compile errors at least. yet to test fully.

how many stars do you want?? [tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top