I have a Yes/No field called "Disciplinary Action" in a table. I would like to create a button that changes all of the entries for every record to a "No" when the button is pushed. Right now, some are no and some are yes.
Advanced Beginner
Windows 7 64bit 
Access 2007
I have a Yes/No field called "Disciplinary Action" in a table. I would like to create a button that changes all of the entries for every record to a "No" when the button is pushed. Right now, some are no and some are yes.
VIP
Windows 7 64bit Access 2010 32bit
I use only VBA:
CurrentDb.Execute "UPDATE tablename SET [Disciplinary Action] = False"
A macro can cause an action query object to run.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How to reset tables so that I can change the Data Type from Number to Autonumber?
Sleuth. Can't find the code/macro that performs a reset.
Posting Permissions
Reply With Quote