Re: Creating a 'select all' button

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I tried this but I got an error message that I was missing an operand.
But I'll figure it out.

Thanks so much,
--
Desperately seeking info


"fredg" wrote:

On Wed, 4 Feb 2009 13:16:01 -0800, Juniper wrote:

Hi all,

I have created a check box for a project that I'm working on in which I have
to select over 7,000 records in this database.

Is there a way for me to create a 'select all' button that will allow me to
select all the records instead of doing it one by one?

I'm using Microsoft Access 2003.

You mean you wish to set the check box to true for each record?
Just run an Update query.
Code the Click event of a Command Button:

CurrentDb.Execute "Update MyTable Set MyTable.[CheckBoxName] =
True;",dbFailIOnError

To then uncheck the field for all records:

CurrentDb.Execute "Update MyTable Set MyTable.[CheckBoxName] =
False;",dbFailIOnError
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

.

Quantcast