How can I check off all the boxes in one column in Access?

  • Thread starter Thread starter debbi
  • Start date Start date
D

debbi

I want to send out a mailing to a much wider audience than usual. Instead of
going through name by name and check off the "Mailing" checkbox, is there any
way I can put checks in the whole column at once?
 
Look up update query.

What you would do is create an update query, go to the mailing column and
under the criteria type in -1.

-1 Is the value of a checked checkbox and will check the boxes for you
 
If a query is filtering the table you could just remove the criteria from
the query. Either that or you can base the mailing directly on the table.
In either case there seems to be no need to alter the table data. However,
if you want to do that you could look into Update Query.
 
Yes, you can run an update query that sets all the Mailing checkbox to TRUE.

UPDATE YourTable
SET Mailing = True

And if there are criteria you want to use then you can use something like

UPDATE YourTable
SET Mailing = [City] = "Omaha"

That would mark Mailing True for every record that had Omaha as the city and
false for all the other records.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Debbi,

Do you have this list of names in a form? If so, I usually just add "Select
All" and "Clear All" buttons to the footer of the form. Then, when I click
on either button, it fires an update query that either checkes or unchecks
all of the records for the form. I also have a "Email" button that creates
an email and pastes the email addresses of all of the selected records into
the To: box.

Private Sub cmd_Select_All_Click

Dim strSQL as string
strSQL = "Update tbl_People SET Mailing = True"
currentdb.execute strsql, dbfailonerror
me.requery

End sub
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Back
Top