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.. --- In [EMAIL PROTECTED], "hussaingull" <[EMAIL PROTECTED]> wrote: > > Thank you very much, you give me clear idea about adaffecurent. > can you help me in an other problem, i want to show the database > record in MS Flex Grid, how can i do this. i have 14 fields in an > access database and i want to show all records in Ms Flex Grid. if > you know about this please let me know. > > Thank you very much > > Regards, > Hussain Ali > > > > ATTN: Hussain Ali > > > > Regarding your question about "addaffectcurrent" > > > > When you query the database and return a zero value like "SELECT * > > FROM table WHERE idnumber=' <--- if this query find records the > > cursor will move to the first record it found..and this record > will > > be the default record to be deleted,edit or update...Let say your > > Query has a 10 record result..and you want to delete all this 10 > > record ...well my solution to this is like this.. > > > > for i=1 to rec.recordcount > > .Delete adAffectCurrent > > next i > > > > rec.close > > > > OR: > > .delete addaffectall > > > > FINISH > > > > Hope this explanation will help.. > > > > :-) drumric01 from Phil Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links 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 the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? All your favorites on one personal page � Try My Yahoo! [Non-text portions of this message have been removed] ------------------------ 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=18249 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/
