Deselect all checkboxes by one query

[colleen1980]

Hi: In my table there is a field of type checkbox. I create a button on
my form and wants to deselect all the checkboxes in that field
(PrintQueue).

Table: Research_New
PrintQueue Format Yes/No

Thanks for help.

[Fred Zuckerman]

(air code)
UPDATE Research_New Set PrintQueue = 0
Fred Zuckerman

<co*********@gm ail.comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi: In my table there is a field of type checkbox. I create a button on
my form and wants to deselect all the checkboxes in that field
(PrintQueue).

Table: Research_New
PrintQueue Format Yes/No

Thanks for help.

[colleen1980]

It gives error:
Invalid operation
-------------------------------------
UPDATE Research_New Set PrintQueue = 0
Table: Research_New
PrintQueue Data Type: Yes/No
--------------------------------------------------
Fred Zuckerman wrote:

(air code)
UPDATE Research_New Set PrintQueue = 0
Fred Zuckerman

<co*********@gm ail.comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi: In my table there is a field of type checkbox. I create a button on
my form and wants to deselect all the checkboxes in that field
(PrintQueue).

Table: Research_New
PrintQueue Format Yes/No

Thanks for help.

[Fred Zuckerman]

It works for me on a test.
Are you sure of your table name, field name, and data type?
Are you running the statement from code in a form event or are you pasting
directly into a query.
If you're running from code, then what is your statement (exactly)? And
which event?

Code should be something like:
DoCmd.RunSQL "UPDATE Research_New Set PrintQueue = 0"

Fred Zuckerman
<co*********@gm ail.comwrote in message
news:11******** *************@7 4g2000cwt.googl egroups.com...

It gives error:
Invalid operation
-------------------------------------
UPDATE Research_New Set PrintQueue = 0
Table: Research_New
PrintQueue Data Type: Yes/No
--------------------------------------------------
Fred Zuckerman wrote:

(air code)
UPDATE Research_New Set PrintQueue = 0
Fred Zuckerman

<co*********@gm ail.comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi: In my table there is a field of type checkbox. I create a button

on

my form and wants to deselect all the checkboxes in that field
(PrintQueue).
>
Table: Research_New
PrintQueue Format Yes/No
>
Thanks for help.
>

[colleen1980]

Can any one please tell me the steps that how to run an update query on
the table

Thank You.

[Rick Brandt]

co*********@gma il.com wrote:

Can any one please tell me the steps that how to run an update query
on the table

Thank You.

Where? From Code? Manually via the GUI?

To run an update query manually you create a new query, add your table, set
the query type in the menu to UPDATE and then configure the changes you want
to make to the desired columns and then presss the exclamation point button
in the toolbar. If you save an UPDATE query then it can be run simply by
opening it from the db window.

From code you can run a saved UPDATE query with...

DoCmd OpenQuery "QueryName"

or (preferred)

CurrentDB.Execu te "QueryName" , dbFailOnError

You can also use...

DoCmd.RunSQL "UPDATE SQL Statement"

or

CurrentDB.Execu te "UPDATE SQL Statement", dbFailOnError

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com