By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Help with a form and checkbox

P: n/a
I am not an expert at access and I need a little help with a form. I
have a form that is linked to a table with address information. My form
has a checkbox linked to a field in the database to show when an
address has been gone through and confirmed. I would like to have a box
on the form that shows how many records have been checked and have "-1"
in the table. I don't know how to do this and I asked a consultant that
helps me from time to time and he said that it was complicated and
would take almost a day to complete.
I didn't think that it sounded like a difficult think to do and I
thought I would ask people who know more than I do. Thanks for any help.

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 30 Jun 2005 08:27:04 -0700, mo*********@att.net wrote:
I am not an expert at access and I need a little help with a form. I
have a form that is linked to a table with address information. My form
has a checkbox linked to a field in the database to show when an
address has been gone through and confirmed. I would like to have a box
on the form that shows how many records have been checked and have "-1"
in the table. I don't know how to do this and I asked a consultant that
helps me from time to time and he said that it was complicated and
would take almost a day to complete.
I didn't think that it sounded like a difficult think to do and I
thought I would ask people who know more than I do. Thanks for any help.


Add an unbound control to the form.
Set it's Control source to:
=ABS(SUM([CheckBoxName]))

Also code the Check Box AfterUpdate event:
Me.Refresh

so that any changes are immediately shown in the control.

Almost a day to do, huh!!!
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
On 30 Jun 2005 08:27:04 -0700, mo*********@att.net wrote:
I am not an expert at access and I need a little help with a form. I
have a form that is linked to a table with address information. My form
has a checkbox linked to a field in the database to show when an
address has been gone through and confirmed. I would like to have a box
on the form that shows how many records have been checked and have "-1"
in the table. I don't know how to do this and I asked a consultant that
helps me from time to time and he said that it was complicated and
would take almost a day to complete.
I didn't think that it sounded like a difficult think to do and I
thought I would ask people who know more than I do. Thanks for any help.


Add a textbox to the form. In the newly added textbox, put the
following as the ControlSource (under the Data tab in properties):

=DCount("[myfield]","mytable","myfield=-1")

Substitute the correct names for your field and your table.

Almost a day to complete, huh? I wonder what else you are paying
through the nose for?

mike

Nov 13 '05 #3

P: n/a
Thank you very much for your replys. The box works great now, just like
I needed. I only used my consultant a few times, most of it was a
learning experience. I try to do it on my own now and I guess I learned
enough to ask in the right place. Thanks again.

Nov 13 '05 #4

P: n/a

<mo*********@att.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Thank you very much for your replys. The box works great now, just like
I needed. I only used my consultant a few times, most of it was a
learning experience. I try to do it on my own now and I guess I learned
enough to ask in the right place. Thanks again.


This is, indeed, a good place to ask.

The FAQ for this newsgroup at http://www.mvps.org/access is also a great
source of information. It even includes
http://www.mvps.org/access/netiquette.htm, which is as chock-full of good
suggestions about effectively using this and other newsgroups as the rest of
the site is full of good information about Access, and links to other
sources of information. Another site with some of the same, and a few
different, links is http://ntaccess.tripod.com.

You'll find a good many other references posted here from time to time, too.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.