reverse checkbox code

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
 
If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
Click to expand...
create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]
 
If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
Click to expand...

create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]
Click to expand...

Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting

If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place

"Not [Customers].[Check2]" (Without the quotes.)
 
If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
Click to expand...

create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]
Click to expand...

Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting

If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place

"Not [Customers].[Check2]" (Without the quotes.)
Click to expand...

The query, in SQL view, should read:

Update Customers Set Customers.[Check2] = Not [Check2];

Any checked [Check2] will become unchecked.
Any unchecked [Check2] will become checked.
 
(e-mail address removed):
If someone was stupid enough to enter the data into a checkbox
backwards and wanted to reverse it ... could someone please suggest
the best and simplest way to do that???
In other words what is now TRUE should be changed to FALSE and vice
versa.
Thanks
create an update query using the Wizad. Select the checkobox and set
the update to row to not [tableName].[CheckboxName]
Click to expand...
Click to expand...
Hi Bob .. Thanks for the response, however I'm not clear on what you
are suggesting
Click to expand...
If my table is named Customers and the Cbox is Check2 then you are
suggesting in the Update To box I place
Click to expand...
"Not [Customers].[Check2]" (Without the quotes.)
Click to expand...

The query, in  SQL view, should read:

Update Customers Set Customers.[Check2] = Not [Check2];

Any checked [Check2] will become unchecked.
Any unchecked [Check2] will become checked.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks Fred
 
Back
Top