Hi,

Private Sub Update_Click() With rs rs.Open "Update Sales Set Paid = PAID", db, adOpenDynamic, adLockOptimistic End With End Sub

I want to update the blank field (200 empty rows) with "PAID". The above code does nothing.
I am using MS Access database.
Table Name is : Sales
Field Name is : Paid

Please help.

Sneha

____________________________
Sneha

Hi Sneha

If you want to use the update command then you do it with the connection and not the recordset.

Dim cn as adodb.connection dim recs as long set cn = new adodb.connection cn.open <your connection string> cn.execute "Update Sales Set Paid = 'PAID'",recs,adcmdtext cn.close set cn = nothing msgbox recs & " records updated"

Steve



[Edited by steve_w on 18-06-2006 at 03:04 PM GMT]

quote:

---

steve_w wrote:
Hi Sneha

If you want to use the update command then you do it with the connection and not the recordset.


Steve

---

quote:

---

steve_w wrote:
Hi Sneha

If you want to use the update command then you do it with the connection and not the recordset.


Steve

---