Assigning checkbox weight (score) in a form

[sboegeman via AccessMonster.com]

Hello -

I need to assign a weight (score value) to a checkbox field. The weights
assigned to each checkbox will change, so the boss needs have the ability to
manage the checkbox weights in an administrative form. Then, the calculation
between the checkbox field and the weight is presented in a report. In
addition, the report has to take into account the different weights assigned
to each field over time. For example, over a period of 2 months, the checkbox
weight could have a value of 1, 2, and 3 points. What is the best way to
handle this?

Thanks!!!

Steve

 

[Allen Browne]

To answer you question, you need to separate out 2 things in your thinking:
what is stored in your table (data structure) and how things look on screen
(interface.)

In the table, you need a Number field. The value stored needs to be the
number assigned at the time.

Your interface might include an unbound option group where each option
button/check box is currently assigned a value. In the AfterUpdate event of
the option group, you would assign that value to the (hidden) number field.
That allows you to use the kind of interface you want, and yet store the
value that doesn't change over time.

Presumably you would use the Current event of the form to clear the option
group (assign Null to its Value), since the stored value may not match any
of the current option group choices.

 

[sboegeman via AccessMonster.com]

Hi Allen -

Thank you for your reply.

What my employer wants to do is to store the all field names in a table and
manage them in a form. Here is an example:

Name Category PointValue Active

Field 1 Category1 1
yes
Field 2 Category2 2
no
Field 3 Category1 3
no

I explained to him that I don't see a way to do this. He is confusing table
fields with form controls. What do you think?

To answer you question, you need to separate out 2 things in your thinking:
what is stored in your table (data structure) and how things look on screen
(interface.)

In the table, you need a Number field. The value stored needs to be the
number assigned at the time.

Your interface might include an unbound option group where each option
button/check box is currently assigned a value. In the AfterUpdate event of
the option group, you would assign that value to the (hidden) number field.
That allows you to use the kind of interface you want, and yet store the
value that doesn't change over time.

Presumably you would use the Current event of the form to clear the option
group (assign Null to its Value), since the stored value may not match any
of the current option group choices.

I need to assign a weight (score value) to a checkbox field. The weights
assigned to each checkbox will change, so the boss needs have the ability

[quoted text clipped - 12 lines]

Steve

 

[Allen Browne]

That's not clear to me.

In any case, it's not going to cope with historical values over time as the
point values change.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen -

Thank you for your reply.

What my employer wants to do is to store the all field names in a table
and
manage them in a form. Here is an example:

Name Category PointValue
Active

Field 1 Category1 1
yes
Field 2 Category2 2
no
Field 3 Category1 3
no

I explained to him that I don't see a way to do this. He is confusing
table
fields with form controls. What do you think?

To answer you question, you need to separate out 2 things in your
thinking:
what is stored in your table (data structure) and how things look on
screen
(interface.)

In the table, you need a Number field. The value stored needs to be the
number assigned at the time.

Your interface might include an unbound option group where each option
button/check box is currently assigned a value. In the AfterUpdate event
of
the option group, you would assign that value to the (hidden) number
field.
That allows you to use the kind of interface you want, and yet store the
value that doesn't change over time.

Presumably you would use the Current event of the form to clear the option
group (assign Null to its Value), since the stored value may not match any
of the current option group choices.

I need to assign a weight (score value) to a checkbox field. The weights
assigned to each checkbox will change, so the boss needs have the
ability

[quoted text clipped - 12 lines]

Steve

 

[sboegeman via AccessMonster.com]

An excellent point, Allen.

My employer is confused. He created a table and inserted all the field names
in the database as values in the table under the column "Description." Since
the field names are values in his table, he feels that he can assign the
field names weights and attributes based upon the other fields he created in
the table. I explained to him that you cannot use records to manage database
structure. He sees the table design view in Access and the fields are listed
vertically. In the table that he created that contains the field names the
values are listed vertically because the values are records in the table. He
and I went over this for a good part of the day today but I just could not
explain to him that I see no way to do what he wants.

Steve

To answer you question, you need to separate out 2 things in your thinking:
what is stored in your table (data structure) and how things look on screen
(interface.)

In the table, you need a Number field. The value stored needs to be the
number assigned at the time.

Your interface might include an unbound option group where each option
button/check box is currently assigned a value. In the AfterUpdate event of
the option group, you would assign that value to the (hidden) number field.
That allows you to use the kind of interface you want, and yet store the
value that doesn't change over time.

Presumably you would use the Current event of the form to clear the option
group (assign Null to its Value), since the stored value may not match any
of the current option group choices.

I need to assign a weight (score value) to a checkbox field. The weights
assigned to each checkbox will change, so the boss needs have the ability

[quoted text clipped - 12 lines]

Steve