Newbee needs help - How to delete Current record on a recordset lo

[Newbee Adam]

when looping through a table in Access , can I use a statement to tell access
to update or delete the current record the loop is on.
something like :

DoCmd.RunSQL ("DELETE * FROM this record)

 

[Lynn Trapp]

You need a Where clause in your Delete query or, else, you will delet all
records from your table.

DELETE *
FROM YourTable
WHERE SomeField = SomeValue;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[fredg]

when looping through a table in Access , can I use a statement to tell access
to update or delete the current record the loop is on.
something like :

DoCmd.RunSQL ("DELETE * FROM this record)

Something like this.

Dim Db As DAO.Database
Dim rs As DAO.Recordset
Set Db = CurrentDb
Set rs = Db.OpenRecordset("TableName")

With rs
.MoveFirst
Do While Not .EOF
If !FieldName = SomeCriteria Then
rs.Delete
End If
rs.MoveNext
Loop
End With

Exit_This_Sub:
Set Db = Nothing
Set rs = Nothing
Exit Sub

 

[Newbee Adam]

thank you both.

Yes I see waht you me Lynn, I was thinking since it was in a loop it would
know to just delete the current record.
So instead of sql I did of corse :
rs.delete simple as it is, guess that is why they call me newbie!!!!!!!