Update multiple records using checkboxes

[Targa]

Searched the NG but no luck.

Im displaying records from an Access2000 db in a table. The table is within
a form and each record(row) has a checkbox next to it.

I need to create an update statement that will update each record that has
its checkbox checked.

How can I do this?

Thanks!

[Targa]

Think Im on the right track but now getting error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Here's my code:
strCallback= request.QueryString("Callback")
response.write strCallback
sql = "UPDATE Schedule SET Callback = 'Yes' WHERE ID IN (strCallback)"

Any ideas?

Thanks!

>
> Im displaying records from an Access2000 db in a table. The table is

within

> a form and each record(row) has a checkbox next to it.
>
> I need to create an update statement that will update each record that has
> its checkbox checked.
>
> How can I do this?
>
> Thanks!
>
>
>

[Bob Lehmann]

sql = "UPDATE Schedule SET Callback = 'Yes' WHERE ID IN (" & strCallback &
")"

Bob Lehmann

"Targa" <targa1SPAMSUCKS@alltel.net> wrote in message
news:#QrhbrqPEHA.3708@TK2MSFTNGP10.phx.gbl...

> Think Im on the right track but now getting error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
>
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
>
> Here's my code:
> strCallback= request.QueryString("Callback")
> response.write strCallback
> sql = "UPDATE Schedule SET Callback = 'Yes' WHERE ID IN (strCallback)"
>
> Any ideas?
>
> Thanks!
>
>
>

> >
> > Im displaying records from an Access2000 db in a table. The table is

> within

> > a form and each record(row) has a checkbox next to it.
> >
> > I need to create an update statement that will update each record that

has

> > its checkbox checked.
> >
> > How can I do this?
> >
> > Thanks!
> >
> >
> >

>
>

[Targa]

Excellent - Thanks Bob!


"Bob Lehmann" <none> wrote in message
news:O8fpJwqPEHA.2996@TK2MSFTNGP12.phx.gbl...

> sql = "UPDATE Schedule SET Callback = 'Yes' WHERE ID IN (" & strCallback &
> ")"
>
> Bob Lehmann
>
> "Targa" <targa1SPAMSUCKS@alltel.net> wrote in message
> news:#QrhbrqPEHA.3708@TK2MSFTNGP10.phx.gbl...

> > Think Im on the right track but now getting error:
> > Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
> >
> > [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

1.

> >
> > Here's my code:
> > strCallback= request.QueryString("Callback")
> > response.write strCallback
> > sql = "UPDATE Schedule SET Callback = 'Yes' WHERE ID IN (strCallback)"
> >
> > Any ideas?
> >
> > Thanks!
> >
> >
> >

> > >
> > > Im displaying records from an Access2000 db in a table. The table is

> > within

> > > a form and each record(row) has a checkbox next to it.
> > >
> > > I need to create an update statement that will update each record that

> has

> > > its checkbox checked.
> > >
> > > How can I do this?
> > >
> > > Thanks!
> > >
> > >
> > >

> >
> >

>
>