Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to create a vba code to change checkbox value to TRUE in access for all records in a query?

Posted on 2015-02-24
2
Medium Priority
?
1,471 Views
Last Modified: 2016-02-10
I have a form called “frmDailyReport”.  When I select an assignment group from the dropdown menu and run the report, I want to tag all of the records in the report as been sent.  I want to accomplish this by changing the value for the checkbox in the “Site Notified” field to “Yes” in the Audit Data table.  Please see the attached sample DB.

qryAuditsComplete:  Query to select all records that have been audited; Uses the frmDailyReport for criteria

qrySiteGroupList:  Query for dropdown list for the frmDailyReport

frmDailyReport:  Input for qryAuditsComplete
Sample.accdb
0
Comment
Question by:kbay808
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40629886
create a query like this

Update [Audit Data]
Set [Site Notified]=-1
Where [Assignment Group]=[forms]![frmDailyReport]![SiteGroupInput]

save the query as qryUpdate  and call it in the macro after opening the report

in VBA

see the codes behind the button Run Report VBA

see attached db
Sample.accdb
0
 

Author Closing Comment

by:kbay808
ID: 40629898
Thank you very much
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question