Able to DELETE Query Generate in Table? "edisonl via AccessMonster.com" <u47544[ at ]uwe> 12/4/2008 10:36:33 AM Hi, My subform output from a query running behind, Can I detect which recordset user selected ? Also Will I able to delete the recordset? Cause it seems that Query generated Recordsets do not permit deletion though i open the Subform.AllowDeletions =True Edison -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Re: Able to DELETE Query Generate in Table? John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/4/2008 5:40:46 PM On Thu, 04 Dec 2008 10:36:33 GMT, "edisonl via AccessMonster.com" <u47544[ at ]uwe> wrote: [Quoted Text] >Hi, > >My subform output from a query running behind, Can I detect which recordset >user selected ? >Also Will I able to delete the recordset? Cause it seems that Query generated >Recordsets do not permit deletion though i open the Subform.AllowDeletions >=True > > >Edison Some queries are updateable, and some aren't. How is the user selecting the recordset? Do you want to "delete the recordset" or do you want to delete records in the table (via the query)? More details please! -- John W. Vinson [MVP]

Re: Able to DELETE Query Generate in Table? "edisonl via AccessMonster.com" <u47544[ at ]uwe> 12/5/2008 12:01:56 AM Hi John, Thank you for replyin... I want the user to select recordset via record seleector and a button on_click event to delete it.. Is there a method I can do it programatically ? Edison John W. Vinson wrote: [Quoted Text] >>Hi, >> >[quoted text clipped - 5 lines] >> >>Edison > >Some queries are updateable, and some aren't. How is the user selecting the >recordset? Do you want to "delete the recordset" or do you want to delete >records in the table (via the query)? More details please! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1

Re: Able to DELETE Query Generate in Table? John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/5/2008 12:41:13 AM On Fri, 05 Dec 2008 00:01:56 GMT, "edisonl via AccessMonster.com" <u47544[ at ]uwe> wrote: [Quoted Text] >Hi John, > >Thank you for replyin... > >I want the user to select recordset via record seleector and a button >on_click event to delete it.. How are the "recordsets" created? In VBA code? And what do you want to delete: the records in the underlying Table, the recordset object itself? Are you in fact referring to an Access VBA Recordset object such as Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = db.OpenRecordset("SomeTableName", dbOpenDynaset) or to some other use of the term "recordset"? What's the *real life context*? What ARE these recordsets? -- John W. Vinson [MVP]

Re: Able to DELETE Query Generate in Table? "edisonl via AccessMonster.com" <u47544[ at ]uwe> 12/5/2008 1:12:59 AM Oh John.., Pardon me for misleading and not elaborating enough.. Question 1: In fact My Subform dealing with Query Input from Access 2000 Table. Basically I just did: Form_Onload() Subform1.form.recordsource= "Table1_Query"

Re: Able to DELETE Query Generate in Table? John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/5/2008 5:56:36 AM On Fri, 05 Dec 2008 01:12:59 GMT, "edisonl via AccessMonster.com" <u47544[ at ]uwe> wrote: [Quoted Text] >Oh John.., > >Pardon me for misleading and not elaborating enough.. >Question 1: >In fact My Subform dealing with Query Input from Access 2000 Table. Basically >I just did: >Form_Onload() >Subform1.form.recordsource= "Table1_Query" Ok. Keep going. I have NO idea what the user is selecting from, or what it is that you want to delete. Sorry my telepathy seems to be out of order tonight. -- John W. Vinson [MVP]