RE: HOW DO I EDIT A RECORD IN ADO

THANK YOU !

"squiggy" wrote:

> 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)
  • 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)
  • Replace value in table with DAO
    ... With rst ... >like to replace just the Path leaving the rest ... I use DAO. ...
    (microsoft.public.access.modulesdaovba)
  • 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: Why does my new Access 2003 not recognize Date()?
    ... > Jeff, You are so kind to help me. ... > not allow me to edit my records. ... > address, etc., while the related tables (edited through the sub-forms) are ... Open the References Window again and highlight the DAO object ...
    (microsoft.public.access.queries)