Creating a 'select all' button

  • Thread starter Thread starter Juniper
  • Start date Start date
J

Juniper

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.
 
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.
Click to expand...

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
 
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 said:
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.
Click to expand...

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
Click to expand...
 
Juniper,

If you post the code you are using someone can take a look to see what is
happening...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Juniper said:
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 said:
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.
Click to expand...

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
Click to expand...
Click to expand...
 
Hi Gina,

I created a checkbox called 'Select All' and I need to somehow link this to
three other existing checkboxes called 'auto-renew', 'DNR' and 'verified'. I
want to be able to click on the 'select all' button and have it select all
the records by either one of these checkboxes 'auto-renew', 'DNR' and
'verified'. Sometimes I need to select the records only by 'auto-renew'. So,
the action of select all is only for one checkbox at any given time.

Do I need to create a 'Select All' button for each of the three checkboxes
and how do I create a link between them?

--
Desperately seeking info


Gina Whipp said:
Juniper,

If you post the code you are using someone can take a look to see what is
happening...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Juniper said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Juniper,

Looks like Fredg's snippet will give you what you want or is that not the
way you want to do it? The code could be attched to a button.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Juniper said:
Hi Gina,

I created a checkbox called 'Select All' and I need to somehow link this
to
three other existing checkboxes called 'auto-renew', 'DNR' and 'verified'.
I
want to be able to click on the 'select all' button and have it select all
the records by either one of these checkboxes 'auto-renew', 'DNR' and
'verified'. Sometimes I need to select the records only by 'auto-renew'.
So,
the action of select all is only for one checkbox at any given time.

Do I need to create a 'Select All' button for each of the three checkboxes
and how do I create a link between them?

--
Desperately seeking info


Gina Whipp said:
Juniper,

If you post the code you are using someone can take a look to see what is
happening...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Juniper said:
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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top