Re: HOW DO I EDIT A RECORD IN ADO

Hi,

It would look like

With rst
.Fields("Pro Work").Value = "Yes"
.Fields("Work Date") = Date
.Fields("Status") = "App Not in Work Que"
.Update
End with



--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"squiggy" <squiggy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DBB26C25-E621-435E-BAEE-3FDDBD19E131@xxxxxxxxxxxxxxxx
> PREVIOUSLY, IN DAO I USED CODE SIMILAR TO THIS:
>
> With rst
> .Edit
> ![Pro Work] = "Yes"
> ![Work Date] = Date
> ![Status] = "App Not in Work Que"
> .Update
> End with
>
> How do I edit the same record set using ADO? I have read a few manuals,
> but
> found them a little confusing. My time limits my search on the internet.
>
> I have my connection established and I am able to read data in from my
> record set
> but when my program decisions through the logic it doesn't edit the record
> set.
>


.

Relevant Pages

  • Re: HOW DO I EDIT A RECORD IN ADO
    ... Unlike DAO, in ADO you get a read-only recordset if you ... > How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)
  • Replace value in table with DAO
    ... With rst ... >like to replace just the Path leaving the rest ... I use DAO. ...
    (microsoft.public.access.modulesdaovba)
  • RE: HOW DO I EDIT A RECORD IN ADO
    ... IN DAO I USED CODE SIMILAR TO THIS: ... > With rst ... > How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)
  • HOW DO I EDIT A RECORD IN ADO
    ... With rst ... How do I edit the same record set using ADO? ...
    (microsoft.public.data.ado)
  • Re: RunSQL statement in DAO loop
    ... I checked every Access group I subscribe to, and can't find it at all. ... Doug Steele, Microsoft Access MVP ... I'm parsing down through many records using DAO loop, ... Dim rst As DAO.Recordset ...
    (microsoft.public.access.formscoding)