How can I write a VBA code to count # of "CheckBoxs" that have been checked.

  • Thread starter Thread starter Nadir
  • Start date Start date
N

Nadir

Hi to all,
I need help on how I can write a VBA code to count #
of "CheckBoxs" that have been checked.

Thank you,

Nadir
(e-mail address removed)
 
Nadir,

It is unlikely that this is really a job for a VBA procedure. Or for a
macro, for that matter. You will need to give a lot more information as
regards what these checkboxes represent, what field(s) they relate to,
and whether you want this count in a query, form, or report.
 
Hi,
I am hoping to have it as access data page. I would like
it to be a form on our "Intranet" and the checkboxes
representing "How many patrons asked quiestions (this is a
Library) that referred to Dept1, and how many were for
Dept2 and so on.
So the checked boxes will be counted as 1 when
they "checked", and I will have a box that will keep the
count of all the checked boxes for each Dept. I have about
8 or 9 Dept. I do not need to keep track of the
checkboxes, just the "sum" for each Dept. This is going to
be daily thing (7 days a week) and I need to give a day of
the week month and year.

Thank you,

Nadir
 
Nadir,

I am not familiar with Data Access Pages myself. Maybe you would have a
better chance of a good answer if you post your question to the
microsoft.public.access.dataaccess.pages newsgroup.

If you were doing this on an ordinaru Access form, you could have a
Department field in your Questions table, and on the form represent this
with an Option Group, with a checkbox or option button to represent each
department. Then, in the form footer, you can put 9 unbound textboxes,
one for each department, with the Control Source set to something like
this...
=Abs(Sum([Department]=1))
=Abs(Sum([Department]=2))
.... etc
 
Back
Top