[AccessD] vba to Delete mult records continous form

Kath:

dim db as DAO.Database
Set db = Currentdb

db.Execute "Delete * FROM tblXYZ WHERE fldSomeField = '" & strCriteria & "'"

Without the WHERE clause it will delete all the records in the table.

Rocky

----- Original Message ----- 
From: "Kath Pelletti" <KP at sdsonline.net>
To: <AccessD at databaseadvisors.com>
Sent: Tuesday, May 10, 2005 6:03 PM
Subject: [AccessD] vba to Delete mult records continous form


RESENDING THIS AS IT DIDN'T APPEAR?

--------------------------------------------------------------------------------

Hi everyone - maybe I am just having a bad day but can someone tell me the 
code I need in vba to do the same action as the [Records]  [Delete] menu? 
ie. I have a continuous form, user selects a block of records to delete.

If I use DoCmd.RunCommand acCmdDeleteRecord then it only takes out the first 
rec.

How can I get rid of them all? I could do it with a delete sql string if I 
knew how to reference the selected records.

TIA
Kath

______________________________________________
Kath Pelletti
Software Design & Solutions Pty Ltd.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com