Greg As I recall when I use WithEvents, it was not as useful as you might think. I'll find a ref* to it so you can judge.
I would think the most fruitful places to look for what you want to do, are the blogs/articles of Paul Stubbs, Andrew Whitechapel, and Misha Schneerson. * Try http://msdn.microsoft.com/en-us/library/aa201789(office.10).aspx - else a search for "VBA WithEvents Access" _____ Ian Thomas Victoria Park, Western Australia _____ From: [email protected] [mailto:[email protected]] On Behalf Of Greg Keogh Sent: Thursday, November 11, 2010 6:52 PM To: 'ozDotNet' Subject: RE: Access and .NET COM events Ian, Thomas, The Access developer has successfully registered, referenced and called my Comvisible DLL (that was never in doubt), and has advised me that Access has a WithEvents feature that she has not used with ActiveX components before. However, the fact that it exists hints that it will be possible to register a callback so I can notify the VBA code that a socket has received data. Even as a fallback I'm told that the ancient trick of a spin loop with DoEvents can prevent a freeze while the COM component's socket is busy. We're now experimenting with how .NET Exceptions can be caught in the Access ON ERROR code and be passed useful and reliable information. We have to work out a few of these plumbing conventions before proceeding too far. Greg _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1153 / Virus Database: 424/3247 - Release Date: 11/09/10
