Creating a 'select all' button

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.
--
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
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

If the check boxes are on a form you can write some code to cycle
through each one and check it or uncheck it. There are lots of samples
on the net.

For FREE Access ebook and videos click here
http://access-databases.com/ebook

On 4 Feb, 21:16, 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.
--
Desperately seeking info

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

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" wrote in message
...
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

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" wrote:

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" wrote in message
...
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

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" wrote in message
...
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" wrote:

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" wrote in message
...
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