T
td
I have a large project with many people entering data into a database. (The
records are actually already in the database, but the project staff are
filling in missing data.)
I would like to have on the data entry form an object of some sort that
would show (1) the total project progress, and (2) that individual person's
contribution. I envision this being a thermometer-type graphic, like they
have for fundraisers and such. There would be one thermometer for each of
the two stats described above.
The form is currently set up so that when each staff member is working, the
form looks up their network id and therefore knows who they are. After each
record is entered, the staff click a button which locks the record and enters
their last name in a field, indicating that the record has been completed.
When each person logs on, a global variable (mylastname) is set to their last
name. So I want to somehow have Access show a thermometer where the size of
the thermometer represents the total number of records, and the "mercury" in
the thermometer is at the level representing the percentage of records where
mylastname = the ANALYST field. Then a second similar thermometer showing
the percentage of all records where the ANALYST field is not blank (i.e.,
total progress).
I worked on a project a few years ago (run by someone who I unfortunately
can't get a hold of), that had this type of small thermometer graphic on her
data entry form. It helped give us a sense that we were making progress, and
even instilled some amount of competition amongst the team members. It
definitely motivated some people. If anyone has any idea how to work
something like this up, please let me know.
Alternatively, even if you know how I could just get numbers and percentages
to show up, that would be great too!
Thanks,
T
records are actually already in the database, but the project staff are
filling in missing data.)
I would like to have on the data entry form an object of some sort that
would show (1) the total project progress, and (2) that individual person's
contribution. I envision this being a thermometer-type graphic, like they
have for fundraisers and such. There would be one thermometer for each of
the two stats described above.
The form is currently set up so that when each staff member is working, the
form looks up their network id and therefore knows who they are. After each
record is entered, the staff click a button which locks the record and enters
their last name in a field, indicating that the record has been completed.
When each person logs on, a global variable (mylastname) is set to their last
name. So I want to somehow have Access show a thermometer where the size of
the thermometer represents the total number of records, and the "mercury" in
the thermometer is at the level representing the percentage of records where
mylastname = the ANALYST field. Then a second similar thermometer showing
the percentage of all records where the ANALYST field is not blank (i.e.,
total progress).
I worked on a project a few years ago (run by someone who I unfortunately
can't get a hold of), that had this type of small thermometer graphic on her
data entry form. It helped give us a sense that we were making progress, and
even instilled some amount of competition amongst the team members. It
definitely motivated some people. If anyone has any idea how to work
something like this up, please let me know.
Alternatively, even if you know how I could just get numbers and percentages
to show up, that would be great too!
Thanks,
T