use Radio Button to separate Records

[MackBlale]

I have a radio button that the user can choose if the employee is active or
has been terminated. Each employees pay is listed in the database. I want
to design a qry so that detects if the radio button is on and disregards
those records when adding employees to be paid to a report. My
understanding is that the radio button information does not have to be
stored.

Thanks

 

[Jeff Boyce]

Mack

Disregards which records?

How will the query/report "know" which employees to "add ... to [your]
report"?

If the data ("active" or "terminated") isn't stored in the table, how will
Access know which ones to select?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MackBlale]

Jeff,
I would like to disregard records whose radio button is chosen or on. These
records may come in the form of paid employees that are inactive or
employees who have been terminated. The query will only add records that
don't have these radio buttons selected.

I didn't know if the data had to be stored or not which is why I'm asking
the question in this forum. Thanks for the help with code if possible.

Mack

Mack

Disregards which records?

How will the query/report "know" which employees to "add ... to [your]
report"?

If the data ("active" or "terminated") isn't stored in the table, how will
Access know which ones to select?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a radio button that the user can choose if the employee is active
or has been terminated. Each employees pay is listed in the database. I
want to design a qry so that detects if the radio button is on and
disregards those records when adding employees to be paid to a report. My
understanding is that the radio button information does not have to be
stored.

Thanks

 

[Jeff Boyce]

I'm not following...

If your radio button isn't bound to any field, the record doesn't have the
value of the radio button. If you don't store it, you can't look up using
it.

What am I missing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
I would like to disregard records whose radio button is chosen or on.
These records may come in the form of paid employees that are inactive
or employees who have been terminated. The query will only add records
that don't have these radio buttons selected.

I didn't know if the data had to be stored or not which is why I'm asking
the question in this forum. Thanks for the help with code if possible.

Mack

Mack

Disregards which records?

How will the query/report "know" which employees to "add ... to [your]
report"?

If the data ("active" or "terminated") isn't stored in the table, how
will Access know which ones to select?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a radio button that the user can choose if the employee is active
or has been terminated. Each employees pay is listed in the database. I
want to design a qry so that detects if the radio button is on and
disregards those records when adding employees to be paid to a report.
My understanding is that the radio button information does not have to be
stored.

Thanks

 

[MackBlale]

Jeff,
Ever heard the saying, "you don't know what you don't know?" Well, I didn't
know I had to store the value of the radio button. NOW it all makes sense.
Thanks for pointing out the obvious for me; I just couldn't see it...

I'm not following...

If your radio button isn't bound to any field, the record doesn't have the
value of the radio button. If you don't store it, you can't look up using
it.

What am I missing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
I would like to disregard records whose radio button is chosen or on.
These records may come in the form of paid employees that are inactive
or employees who have been terminated. The query will only add records
that don't have these radio buttons selected.

I didn't know if the data had to be stored or not which is why I'm asking
the question in this forum. Thanks for the help with code if possible.

Mack

Mack

Disregards which records?

How will the query/report "know" which employees to "add ... to [your]
report"?

If the data ("active" or "terminated") isn't stored in the table, how
will Access know which ones to select?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a radio button that the user can choose if the employee is active
or has been terminated. Each employees pay is listed in the database.
I want to design a qry so that detects if the radio button is on and
disregards those records when adding employees to be paid to a report.
My understanding is that the radio button information does not have to
be stored.

Thanks

 

[Jeff Boyce]

Sometimes the trees are just too close!

Glad you spotted it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
Ever heard the saying, "you don't know what you don't know?" Well, I
didn't know I had to store the value of the radio button. NOW it all
makes sense. Thanks for pointing out the obvious for me; I just couldn't
see it...

I'm not following...

If your radio button isn't bound to any field, the record doesn't have
the value of the radio button. If you don't store it, you can't look up
using it.

What am I missing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
I would like to disregard records whose radio button is chosen or on.
These records may come in the form of paid employees that are inactive
or employees who have been terminated. The query will only add records
that don't have these radio buttons selected.

I didn't know if the data had to be stored or not which is why I'm
asking the question in this forum. Thanks for the help with code if
possible.

Mack

Mack

Disregards which records?

How will the query/report "know" which employees to "add ... to [your]
report"?

If the data ("active" or "terminated") isn't stored in the table, how
will Access know which ones to select?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a radio button that the user can choose if the employee is
active or has been terminated. Each employees pay is listed in the
database. I want to design a qry so that detects if the radio button is
on and disregards those records when adding employees to be paid to a
report. My understanding is that the radio button information does not
have to be stored.

Thanks

 

[Sean King]

Jeff,

Reading your post i think your amy be the only guy that can help me.

I have started using access 2003 for a few months now and am getting better the more i learn.

I have recently created a form to log all issues that users of a system have called in about.

when i get a call i bring up the form which has a username field

This username field reference all users of teh system (users table)

The form also has 3 radio status buttons "Active", "Inactive" and "All"

Before i start to input a username into the form i require selecting one of those radio buttons to state whether i want to search on active / inactive or all users that are stored on teh users table.

In the users table there is a column called status which states whether a user is active or iunactive.

The problem is i have no idea on how i can link them

any support would be greatly appreciated.

Thanking you in advance.



Jeff Boyce wrote:

Re: use Radio Button to separate Records
12-Jan-09

Sometimes the trees are just too close

Glad you spotted it..

Regard

Jeff Boyc
Microsoft Office/Access MV


EggHeadCafe - Software Developer Portal of Choice
JavaScript Distributed Slider Weight Control
http://www.eggheadcafe.com/tutorial...4-b693cbe57376/javascript-distributed-sl.aspx

 

[Sean King]

Jeff,

Reading your post i think your amy be the only guy that can help me.

I have started using access 2003 for a few months now and am getting better the more i learn.

I have recently created a form to log all issues that users of a system have called in about.

when i get a call i bring up the form which has a username field

This username field reference all users of teh system (users table)

The form also has 3 radio status buttons "Active", "Inactive" and "All"

Before i start to input a username into the form i require selecting one of those radio buttons to state whether i want to search on active / inactive or all users that are stored on teh users table.

In the users table there is a column called status which states whether a user is active or iunactive.

The problem is i have no idea on how i can link them

any support would be greatly appreciated.

Thanking you in advance.



Jeff Boyce wrote:

Re: use Radio Button to separate Records
12-Jan-09

Sometimes the trees are just too close

Glad you spotted it..

Regard

Jeff Boyc
Microsoft Office/Access MV


EggHeadCafe - Software Developer Portal of Choice
Callback and Manual Partial Page Rendering
http://www.eggheadcafe.com/tutorial...4-00afc3fb9222/callback-and-manual-parti.aspx

 

[Sean King]

Jeff,

Reading your post i think your amy be the only guy that can help me.

I have started using access 2003 for a few months now and am getting better the more i learn.

I have recently created a form to log all issues that users of a system have called in about.

when i get a call i bring up the form which has a username field

This username field reference all users of teh system (users table)

The form also has 3 radio status buttons "Active", "Inactive" and "All"

Before i start to input a username into the form i require selecting one of those radio buttons to state whether i want to search on active / inactive or all users that are stored on teh users table.

In the users table there is a column called status which states whether a user is active or iunactive.

The problem is i have no idea on how i can link them

any support would be greatly appreciated.

Thanking you in advance.



Jeff Boyce wrote:

Re: use Radio Button to separate Records
12-Jan-09

Sometimes the trees are just too close

Glad you spotted it..

Regard

Jeff Boyc
Microsoft Office/Access MV


EggHeadCafe - Software Developer Portal of Choice
Styling WPF UI using Resource Dictionaries
http://www.eggheadcafe.com/tutorial...e-3a58a615c3d7/styling-wpf-ui-using-reso.aspx