I am a lab tech who would like to create a popup form for counting cells when
examining blood using a separate USB keypad to do the count. Variables I
need to manage in doing this are:

(1) TOTAL NUMBER OF CELLS TO COUNT:
Request the user to provide the total number of cells to count (generally in
multiples of 100)

(2) KEY ASSIGNED TO CELL TYPE:
Assign keys on the keypad a label and have the key that is struck increase
the value by "1" each time it is struck untill the total number of cells to
count is reached

(3) RUNNING TOTAL:
Keep a running sum of of all keys struck

(4) RUNNING PERCENTAGE:
Provide a running percentage for how often each key has been struck

(5) "Beep" when the total number of cells is reached

In my mind this seems like there should be an easy way to do this but I
cannot find a command that allows me to set a key to count (perhaps using
"keydown" there is a way to do this). Although Im have created some complex
databases, I am not a software programmer. Perhaps this is better handled as
a separate application in C# that with a button assigned to run. I just
downloaded C# express but have no familiarity with it.

Thanks.

You could use the Keypress event of a text box. Then for each key you will
want to include, you will need a text box to accumulate the number of times
it was pressed. You will also want a text box to accumulate all the presses
for your total and one to present the percentages.

Do some reading on the KeyPress event in VBA Help.
--
Dave Hargis, Microsoft Access MVP


"David Hematologist" wrote:

> I am a lab tech who would like to create a popup form for counting cells when
> examining blood using a separate USB keypad to do the count. Variables I
> need to manage in doing this are:
>
> (1) TOTAL NUMBER OF CELLS TO COUNT:
> Request the user to provide the total number of cells to count (generally in
> multiples of 100)
>
> (2) KEY ASSIGNED TO CELL TYPE:
> Assign keys on the keypad a label and have the key that is struck increase
> the value by "1" each time it is struck untill the total number of cells to
> count is reached
>
> (3) RUNNING TOTAL:
> Keep a running sum of of all keys struck
>
> (4) RUNNING PERCENTAGE:
> Provide a running percentage for how often each key has been struck
>
> (5) "Beep" when the total number of cells is reached
>
> In my mind this seems like there should be an easy way to do this but I
> cannot find a command that allows me to set a key to count (perhaps using
> "keydown" there is a way to do this). Although Im have created some complex
> databases, I am not a software programmer. Perhaps this is better handled as
> a separate application in C# that with a button assigned to run. I just
> downloaded C# express but have no familiarity with it.
>
> Thanks.
>
>
>
>

Thanks Klatuu,

I have been able to muddle by using macros, but I am guessing from what you
say I will have to break down and learn some VAB code. It's good to know
where to start looking. Thanks for the reply.

"Klatuu" wrote:

> You could use the Keypress event of a text box. Then for each key you will
> want to include, you will need a text box to accumulate the number of times
> it was pressed. You will also want a text box to accumulate all the presses
> for your total and one to present the percentages.
>
> Do some reading on the KeyPress event in VBA Help.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "David Hematologist" wrote:
>
> > I am a lab tech who would like to create a popup form for counting cells when
> > examining blood using a separate USB keypad to do the count. Variables I
> > need to manage in doing this are:
> >
> > (1) TOTAL NUMBER OF CELLS TO COUNT:
> > Request the user to provide the total number of cells to count (generally in
> > multiples of 100)
> >
> > (2) KEY ASSIGNED TO CELL TYPE:
> > Assign keys on the keypad a label and have the key that is struck increase
> > the value by "1" each time it is struck untill the total number of cells to
> > count is reached
> >
> > (3) RUNNING TOTAL:
> > Keep a running sum of of all keys struck
> >
> > (4) RUNNING PERCENTAGE:
> > Provide a running percentage for how often each key has been struck
> >
> > (5) "Beep" when the total number of cells is reached
> >
> > In my mind this seems like there should be an easy way to do this but I
> > cannot find a command that allows me to set a key to count (perhaps using
> > "keydown" there is a way to do this). Although Im have created some complex
> > databases, I am not a software programmer. Perhaps this is better handled as
> > a separate application in C# that with a button assigned to run. I just
> > downloaded C# express but have no familiarity with it.
> >
> > Thanks.
> >
> >
> >
> >