i think there is a slight confussion hussain gull is using MS Flex Grid in his application and the solution provided by drumric01 is for MS Hierarchical Flex Grid
if u use MSHFlexGrid u can directly set recordset to it like set MSHFlexGrid1.recordset = rs but u donot have a property called recordset in MSFlexGrid control if u r using MSFlexGrid control u have to manually iteriate through the recordset and put the values in the grid the choice is yours hussain Regards, Prashant On Thu, 2 Dec 2004 20:35:35 -0800 (PST), hussain ali <[EMAIL PROTECTED]> wrote: > > Dear, > > the problem is still there. i followed as you said, but it give an error > message when i use this code. > > Waiting for your reply. > > Regrads, > Hussain Ali > > > > drumric01 <[EMAIL PROTECTED]> wrote: > > let assume you have a variable "rec" as adodb.recordset > after setting this variable(configuring and opening) > do this: > > set mshflexgrid.recordset=rec.recordset > > OR > > set Mshflexgrid.recordset=rec > > rec.close > set rec=nothing '<--- To free-up your memory > > Hope this will help.. Drumric01 From Phil.. > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=18260 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
