select and update multiple records at the same time


David Pelizzari

I am working on an Access 2007 front end to an SQL 2005 database. Each
record has a binary (check box) to be checked once the work required on the
record is performed. How would I allow someone on the datasheet view to
select all the records and check them all automatically? How about a range
(from x to y records were done)? I suppose I could put a button on the form
view (not the datasheet) to mark all as complete, but they would have
difficulty verifying it was done.

Crystal (strive4peace)

Hi David,

if you are comfortable with SQL, you can construct the SQL
for an Update Query in code.

Alternately, you can use code to loop through the records
that are displayed using RecordsetClone and change all the
values. I do not know of a way to act on selected records
but you could use a command button to select all or
de-select all.

Warm Regards,
remote programming and training

free video tutorials

Access Basics
free 100-page book that covers essentials in Access

:) have an awesome day :)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question