Steve Erbach
erbachs at gmail.com
Mon Apr 4 15:02:17 CDT 2005
Jim, Interesting. Do you know, I have never tried to use an ActiveX control in an Access application. I think I'll stick with Jim H.'s many-to-many linking tables idea, if you don't mind. Thanks for your input. Steve Erbach On Apr 4, 2005 7:12 AM, Jim Lawrence <accessd at shaw.ca> wrote: > Hi Steve: > > Have you tried looking into the use of a flexgrid? If you have access to VB6 > or the like, the flexgrid can be used by referencing the FlexGrid control > 'msflxgrd.ocx', the Hierarchical FlexGrid control 'mshflxgd.ocx' or/with the > ADO Shape control 'msadodc.ocx' (available through ADO 2.0 and up). > > I have only had to reference the Hierarchical FlexGrid once for a client > when the requirement was for viewing data in various groupings depending on > which column, from the list presented that was selected. The grid would > re-form with each click. The control names might be slightly dated (dlls > might be used now) as the application was created at least five years ago > and it has not required changing in these areas. > > See Microsoft reference to the flex controls at: > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/htm > l/vbconhflexgridcontrol.asp (watch for wrap) > > Or a sample ADO shape command being used: > http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=6512&lng > WId=4 > > Without going into great detail... > > HTH > Jim