Mark Simms
marksimms at verizon.net
Thu Dec 2 20:02:05 CST 2010
Opened an AC2003 MDB that had a form using MSCOMCTL's "Listview" control. Environment: Windows 7 64 Bit with AC2007 / SP2. I try to debug the VBA code where the Listview control population was occuring. Access IGNORED my STOP statement; ignored all BREAKPOINTS. However, the code did compile cleanly (go figure). This was driving me crazy (we've all been there with Access, right ?) So I fire-up REGEDIT and find the reference to the MSCOMCTL.OCX. There are TWO of them...one in \Windows\System32....the other in \Windows\SysWow64. So I pull up the References dialog box within the VBA environment.....and note there are no references to MSCOMCTL showing ! I browse to SysWow64, find the MSCOMCTL.OCX which was dated 2008, add it, and move it up in priority. I close AC2007, re-open....and ALL IS WELL. I can now debug again ! But more importantly.....Hey.... I like that Listview control with the sortable column headers....why didn't MSFT make that a native control in 2007 ?