Deleting a group of records in a Recordset

[Guest]

Hi. I am looking for help with deleting records from a recordset.

I have a recordset which is filtered and should only contain those records
the user "Marked" for deletion. How can I delete all the records from this
recordset easily. I hoping for a one-line command like rst.deleteall. I do
a lot of Foxpro programming and sometimes the difference between Access VBA
and Foxpro is frustrating.

Thanks so much for any help you can give.

 

[AccessVandal via AccessMonster.com]

Hi. I am looking for help with deleting records from a recordset.

I have a recordset which is filtered and should only contain those records
the user "Marked" for deletion. How can I delete all the records from this
recordset easily. I hoping for a one-line command like rst.deleteall. I do
a lot of Foxpro programming and sometimes the difference between Access VBA
and Foxpro is frustrating.

Thanks so much for any help you can give.

Well, with wizard you can create a command button on your form
to delete a record, but you will need to edit VB.

delete away this,
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

insert this,
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True