Able to DELETE Query Generate in Table?

[edisonl via AccessMonster.com]

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

 

[John W. Vinson]

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!

 

[edisonl via AccessMonster.com]

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

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!

 

[John W. Vinson]

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?

 

[edisonl via AccessMonster.com]

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"

 

[John W. Vinson]

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.