Command button clearing checkboxes

[HowardChr]

Is there a way to code a command button on a form that will clear all "-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update "InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[UrbanSpaceman]

CurrentDb.Execute "UPDATE TableName SET TableName.FieldName = False;",
dbFailOnError

"HowardChr" <u33744@uwewrote in message news:7155b3d2b585b@uwe...

Is there a way to code a command button on a form that will clear all "-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update
"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[HowardChr]

When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I am
getting an error message that states "expected end of statement" and it
highlights the word SET. Am I doing something wrong?
UrbanSpaceman wrote:

>CurrentDb.Execute "UPDATE TableName SET TableName.FieldName = False;",
dbFailOnError

>Is there a way to code a command button on a form that will clear all "-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update
"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[UrbanSpaceman]

Try pasting your SQL into the query design window and execute it there. If
you get no errors then the problem is probably with the VBA command you're
using (or maybe the previous line of code).

"HowardChr" <u33744@uwewrote in message news:71563ec3d9850@uwe...

When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I
am
getting an error message that states "expected end of statement" and it
highlights the word SET. Am I doing something wrong?
UrbanSpaceman wrote:

>>CurrentDb.Execute "UPDATE TableName SET TableName.FieldName = False;",
dbFailOnError

>>Is there a way to code a command button on a form that will clear all
"-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update
"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[King Ron]

Poor table name choice. You should get into the habit of not using
operators or special characters or spaces in your table and field
names. Access is gakking on the '-'. Qualify the table name by
surrounding it with square brackets:

UPDATE [InputH-1] SET [InputH-1].Refrigeration = False;

On Apr 27, 11:33 am, "HowardChr" <u33744@uwewrote:

When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I am
getting an error message that states "expected end of statement" and it
highlights the word SET. Am I doing something wrong?

UrbanSpaceman wrote:

CurrentDb.Execute "UPDATE TableName SET TableName.FieldName = False;",
dbFailOnError

Is there a way to code a command button on a form that will clear all "-1"
Yes/No fields on a table to show as "0"? I tried to type in: "update
"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[HowardChr]

OK.. that did work to use it in SQL inside a query. (thanks!) The only other
question I would have then is how could I do multiple lines. My specific
tabel has 9 Yes/No boxes, and I would like only one script to run when wanted.
I tried:
UPDATE [InputH-1] SET [InputH-1].Refrigeration = False;
UPDATE [InputH-1] SET [InputH-1].Damaged Product = False;
UPDATE [InputH-1] SET [InputH-1].Weather = False;
UPDATE [InputH-1] SET [InputH-1].Display = False;
UPDATE [InputH-1] SET [InputH-1].Flooring = False;
UPDATE [InputH-1] SET [InputH-1].Debris = False;
UPDATE [InputH-1] SET [InputH-1].Obsticle = False;
UPDATE [InputH-1] SET [InputH-1].Spill = False;
UPDATE [InputH-1] SET [InputH-1].Barcode Missing/Destroyed = False;

But it says characters found at the end of the sql statment. I also tried to
delete the ";"'s and put them all on one line, but that didn't work either.

UrbanSpaceman wrote:

>Try pasting your SQL into the query design window and execute it there. If
you get no errors then the problem is probably with the VBA command you're
using (or maybe the previous line of code).

>When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I
am

[quoted text clipped - 9 lines]

>>>"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[HowardChr]

I did fix it... Thanks for the tid-bit.. I'm sure that will save me a
headache later.

King Ron wrote:

>Poor table name choice. You should get into the habit of not using
operators or special characters or spaces in your table and field
names. Access is gakking on the '-'. Qualify the table name by
surrounding it with square brackets:

UPDATE [InputH-1] SET [InputH-1].Refrigeration = False;

>When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I am
getting an error message that states "expected end of statement" and it

[quoted text clipped - 7 lines]

>"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[HowardChr]

I figured it out. In case anyone else working on a similar issue runs into
this, I had to use the coding:
"UPDATE [InputH-1] SET [InputH-1].Refrigeration = False, [InputH-1].[Damaged
Product] = False, [InputH-1].Weather = False, [InputH-1].Display = False,
[InputH-1].Flooring = False, [InputH-1].Debris = False, [InputH-1].Obsticle =
False, [InputH-1].Spill = False, [InputH-1].[Barcode Missing/Destroyed] =
False;"

HowardChr wrote:

>OK.. that did work to use it in SQL inside a query. (thanks!) The only other
question I would have then is how could I do multiple lines. My specific
tabel has 9 Yes/No boxes, and I would like only one script to run when wanted.
I tried:
UPDATE [InputH-1] SET [InputH-1].Refrigeration = False;
UPDATE [InputH-1] SET [InputH-1].Damaged Product = False;
UPDATE [InputH-1] SET [InputH-1].Weather = False;
UPDATE [InputH-1] SET [InputH-1].Display = False;
UPDATE [InputH-1] SET [InputH-1].Flooring = False;
UPDATE [InputH-1] SET [InputH-1].Debris = False;
UPDATE [InputH-1] SET [InputH-1].Obsticle = False;
UPDATE [InputH-1] SET [InputH-1].Spill = False;
UPDATE [InputH-1] SET [InputH-1].Barcode Missing/Destroyed = False;

But it says characters found at the end of the sql statment. I also tried to
delete the ";"'s and put them all on one line, but that didn't work either.

>>Try pasting your SQL into the query design window and execute it there. If
you get no errors then the problem is probably with the VBA command you're

[quoted text clipped - 5 lines]

>>>>"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?

[paii, Ron]

Try building and testing your queries in the query editor, then switch to
the SQL window to copy and past to your code window. Most of the work will
be done, all you have to do is add quotes and calculated values.Otherwise
save the query and call it by name.

"HowardChr" <u33744@uwewrote in message news:7157218fd658c@uwe...

I figured it out. In case anyone else working on a similar issue runs

into

this, I had to use the coding:
"UPDATE [InputH-1] SET [InputH-1].Refrigeration = False,

[InputH-1].[Damaged

Product] = False, [InputH-1].Weather = False, [InputH-1].Display = False,
[InputH-1].Flooring = False, [InputH-1].Debris = False,

[InputH-1].Obsticle =

False, [InputH-1].Spill = False, [InputH-1].[Barcode Missing/Destroyed] =
False;"

HowardChr wrote:

OK.. that did work to use it in SQL inside a query. (thanks!) The only

other

question I would have then is how could I do multiple lines. My specific
tabel has 9 Yes/No boxes, and I would like only one script to run when

wanted.

I tried:
UPDATE [InputH-1] SET [InputH-1].Refrigeration = False;
UPDATE [InputH-1] SET [InputH-1].Damaged Product = False;
UPDATE [InputH-1] SET [InputH-1].Weather = False;
UPDATE [InputH-1] SET [InputH-1].Display = False;
UPDATE [InputH-1] SET [InputH-1].Flooring = False;
UPDATE [InputH-1] SET [InputH-1].Debris = False;
UPDATE [InputH-1] SET [InputH-1].Obsticle = False;
UPDATE [InputH-1] SET [InputH-1].Spill = False;
UPDATE [InputH-1] SET [InputH-1].Barcode Missing/Destroyed = False;

But it says characters found at the end of the sql statment. I also

tried to

delete the ";"'s and put them all on one line, but that didn't work

either.

>Try pasting your SQL into the query design window and execute it there.

If

>you get no errors then the problem is probably with the VBA command

you're

[quoted text clipped - 5 lines]

>>>"InputH-
1" Set Chooser = 0", but am getting an error. Any ideas?