deleting a row value

[questionit]

If i want to delete a record from a table , i use the following code:

Dim rst As DAO.Recordset
Dim db As DAO.Database
 
Set db = CurrentDb
 
Set rst = db.OpenRecordset("Select name FROM Table1 WHERE name='" & "name1" & "'")
 
rst.Edit
rst.Fields("name") = "name2"
rst.Delete
 

It works. My question is how can i delete a particular field value of a record?

For example: Table1 contains
Name Age
-----------------
Name1 10
Name2 20 --- If i want to delete only 20 not the whole row , how can
it be done ?

2) Also, when i open a RecordSet for delete or update purposes only, why still do i have to write a SELECT statement like above ? Are there any other simple methods out there?

[missinglinq]

You have posted your question in the Articles section rather than the Forum section.

I have moved it across for you.

Linq

[JKing]

I think you want an update query rather than a delete query.

UPDATE tblPerson SET age = Null
WHERE name = 'Jared'
 

You don't need an open recordset to do this either. You can simply use the Docmd.RunSQL command.

Private Sub cmd_Click()
 
Dim strSQL As String
 
strSQL = "UPDATE tblPerson SET age = Null WHERE name = 'Jared'"
 
Docmd.RunSQL strSQL
End Sub
 

There are many other ways to manipulate recordsets and you can open tables directly or even open saved queries. I suggest taking a look at the available methods of a recordset and the examples for them provided in the help files.

[nico5038]

Or even shorter:

currentdb.execute ("UPDATE tblPerson SET age = Null WHERE name = 'Jared'")
 

Nic;o)