Clearing All Checkboxes --Possible?

[Brian]

Is there a way to "clear out" a bunch of checkboxes, so that a database
containing other information could be reused?

I suppose I could save two copies, delete the used one when done, and start
over again...

I was thinking there would be something similar to clearing cells in Excel?
Or, is there a way to use the find/replace function to do this? --Setting
everything back to "unchecked"?

Thanks!

Brian

 

[strive4peace]

Hi Brian,

you can run an UPDATE query on each table

select the fields you want to 'clear' and drag them to the grid

change the query into an update query
from the menu --> Query, Update

in the UpdateTo cell --> False

click on ! to Run the query


Warm Regards,
Crystal

*
have an awesome day
*

 

[Brian]

Thank you so much! Perfect! I learned something new!!

 

[strive4peace]

you're welcome, Brian happy to help

for better understanding of the basics of Access, download and read this:

Access Basics on Allen Browne's site
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
have an awesome day
*

 

[Richard]

you're welcome, Brian happy to help

for better understanding of the basics of Access, download and read this:

Access Basics on Allen Browne's site
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
have an awesome day
*

Brian check out this thread about clearing checkboxes TheAceMan1 explains
it in detail.
http://www.tek-tips.com/viewthread.cfm?qid=1279052