Help Needed: Sorting And Counting Check Boxes

Apr 24, 2006

Hi guys, I'm new to Access and am in great need of some help.
I have a query that serves kind of as an attendance tracker where the students are listed down the left side with the weeks across the top. A check box is in each column that is checked to mark their attendance.

Now the problem: I need to figure out a way to sort by those who have been to 80% or more of the meetings. Preferably by it checking a box automatically in the "80% or more" column. Not sure if Access can do all this. Please help.

Thanks

View Replies

Counting Check Boxes (Yes / No)

Jun 19, 2005

hi guys
i have 2 questions
1.
how can i count selected or not selected checkbox fields (yes/No) in a tex box ?!
( for example we have a 2 yes/no fields that are Male and another Female , and i want to make a form that shows number of males and number of females that selected in a text box )

2.
how can i make a search form that when i chose check boxes and then Search button it will show me the list of selected checkbox that selected in main form

( for example if we have 3 checkboxes 1.(low) 2.(mid) 3.(high) in main database and form , and if i want to make a search form that shows me list of enterees that is (Mid) )

thanks alot

View 8 Replies View Related

Help Needed With Sorting Dates On A Form

Sep 26, 2005

Why won't the dates in the form sort? 9attached) I have tried everything and cannot work out what i am doing wrong - desparate!!

View 1 Replies View Related

Queries :: Query By Form With Check Boxes / Combo Boxes Not Working

Mar 25, 2013

Attached I have a database that I've been working on which has a form called "frmCriteriaSearch". It is based off of the qryCriteriaListBoxUpdate query. I am trying to get the listbox in the second tab of the results section to work. It queries fine for the checkboxes, but I cannot get the comboboxes to affect the query (unless a checkbox has already been selected)

View 6 Replies View Related

Forms :: Search Form Using Both Combo Boxes And Check Boxes

Jun 5, 2014

I am trying to make a search option in my form header. Right now I have two unbound combo boxes (CboAccountsfilter and cboCourseName) that I can use to filter my records. Currently, I can use the drop down for CboAccountsfilter and a list of accounts will appear. When I select one, the corresponding Course Names will appear in cboCourseName. This works fine...Code below. I would like to take the filtering a step farther and add checkboxes to filter the data. I my form, there currently exist several check boxes (yes/no)...(Priority, Rep Top Target, Manager Top Target, ect). I would like to have the option to use a check box to filter. I.E if I had a checkbox in my header called PriorityFilter, if checked it would only bring up those records that met the two combo boxes criteria and was a priority.

Below is the code I have so far...it doesnt have anything for the checkbox because I am at a lost of how to get started.

Private Sub CboAccountsfilter_Change()
Me.Requery
Me.cboCourseName.Requery
Me.Check178.Requery
End Sub

[code]...

View 1 Replies View Related

New Text Boxes And Check Boxes Don't Work

Apr 24, 2008

Hi,
I added some new controls into existing form. I made sure I added those new control names to Table source as well. For some reason, I dont get the values either in the form or in table. Please help. Thanks.
By the way, how can I attach an attachment in this forum. This if first time for me in this forum.

View 4 Replies View Related

Forms :: Sorting Combo Boxes?

Jul 25, 2014

I know I can sort my combo box in ascending or descending order. I have a list of items that I want to order by product code but in a specific way. The order I would like is product code 1 followed by product code 9 followed the rest in ascending order. Without having to change tables or even the product code(!) is there a neat way to do this?

View 10 Replies View Related

HELP! Counting Text Boxes

Mar 20, 2007

I've asked this in a previous post but only got confused. Please forgive me, I'm a newbie at this. I have a table that I need to count a text field.

Table Name: ACE/ARB Table
Field Name: MR# (houses a 8 digit patient number)
Field Name: Failed Patient (houses a "TEXT" field with possible entries of "YES" "NO" or left blank.

Each MR# may have may different entries such as:

MR# 12345678 Failed Patient: YES
MR# 12345678 Failed Patient: NO
MR# 12345678 Failed Patient: NO
MR# 12345678 Failed Patient: (blank)
MR# 87654321 Failed Patient: NO
MR# 87654321 Failed Patient: YES

I need my report to count distinct MR#'s:

From the example above, I would need my report to show/count "2" medical records.

Any help on this would be GREATLY appreciated, I'm going crazy here. Also, if any suggestion has to do with SQL do I type what you would send me directly into the SQL statement from a query?

View 7 Replies View Related

General :: Counting Yes / No Boxes In A Row

May 14, 2013

So I'm fairly new to access as I've only spent one semester working with it. I have a project (work related, not school) that I can't seem to get a handle on.

I have a database with several yes/no fields (y/n)

name | y/n 1 | y/n 2 | y/n 3 | y/n 4 | etc

Is it possible to count how many occurrences of yes appear in each row in the table, and do that for every row? The object is to have a "grading system" if the person has like 4/5 then they are an A while another who has 2/5 is a D.

If this can be done then I can use this to come up with a way to deal with some of the other fields I want to tally and grade.

View 14 Replies View Related

Check Boxes And Text Boxes

Jun 9, 2005

I have a form with a check box among other itmes. What I want to happen is, when the user checks the check box, I want the text box to the right of it to be made visible and to let the user write text. But I only want this text box to be visible when the check box is checked. The check box is if the user wish to put a comment in the form, he will click the check box and then I want my text box to appear so that he may write the comment in the text box. Please help with this. Thanks

View 3 Replies View Related

Forms :: Counting Checked Boxes In A Subform

Feb 18, 2014

I have set up a database to record several different sets of records for a volunteer group that I run. The types of records that I am keeping are hours on duty, uniform issued and attendance at training. The attendance form is a subform which contains a list of dates and the two fields of checkboxes showing if they attended or sent their aplogises.

What I am trying to do is to count the number of times that members attended training. I have set up a 'unbounded' text box in the footer and would just like to add a formula in to the command box of the box properties. Anything more i.e. coding then it goes over my head very quickly.

View 3 Replies View Related

Reports :: Counting Items And Putting Them In Text Boxes?

Jun 6, 2013

I've got a table with 23 columns. Column 1 is the ID row which has a unique client ID in it. Then we've got a column called 1st_Reason and one that goes with it called 1st_Transfer_Date. This pair repeats for 2 through 10. Each of the Reason columns can have a set value, for example "First Processor".

What I need to do is create a date with months on the Y axis and the 5 different reasons on the X axis. I need to count the number of "First Processor" across all 10 Reason columns for each month. I would need to repeat that for each other reason type, but if I can get one to work I can simply change the reason type.

Here's what I'm using to count May's total:

Code:
=Sum(IIf([Current_Reason]="First Processor" And [Current_Processor_Transfer] Between #4/30/2013#
And #6/1/2013#,1,IIf([1st_Reason]="First Processor" And [1st_Transfer_Date] Between #4/30/2013#
And #6/1/2013#,1,0)))+(IIf([2nd_Reason]="First Processor" And [2nd_Transfer_Date] Between #4/30/2013#
And #6/1/2013#,1,IIf([3rd_Reason]="First Processor" And [3rd_Transfer_Date] Between #4/30/2013#

[Code] .....

I get wildly inconsistent results. On one of the types, it's only counting where it's the 1st_Reason. Some of the others return the same value regardless of which month I have selected.

View 2 Replies View Related

Help Needed Filtering A Form Using Combo Boxes

Jul 26, 2006

Please help. My inability to achieve this is very frustrating.

I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes.

For example I have fields showing Product ID, Manufacturer ID, Purchase Order number and due date. Each of these fields has a corresponding unbound combo box where users can select values that appear in the table. I need to be able to filter the form based on what is in these combo boxes. I.e. Filler for a product ID to show all purchase orders numbers and due dates relating to that product ID or filter for a manufacturer ID and due date to show all Product IDs and purchase orders relating to that a manufacturer and date.

Ideally this would be achieved by pressing a command button.

The query, table and combo boxes are all built and work fine but I am unable to get the filter to work, I am using Access 97 and am not very familiar with visual basic. Any help would be appreciated.

Thanks.

View 4 Replies View Related

Check Boxes

Jan 2, 2006

Hi
In my tables I have set a field to Yes/No and the format to be True/False.
When I activate the table it shows the field as a checkbox, however when I create a List Box on a form to that table it displays the fields as True/False, how can I get the list box to also display the field as a checkbox.

dave

View 2 Replies View Related

Sum Of Check Boxes

Jun 9, 2005

I want to sum together the number of check boxes checked. The problem is that Sum gives a negative number. What shuold I do?

View 2 Replies View Related

Check Boxes

Sep 27, 2005

This seems like an easy question.

I created a check box on a form. The problem is once the box is checked, it cannot be unchecked. Seems like there should be some validation running in the background that checks the state of the check box.

I have the value of the check box to equal 1.

If the field is null, then clicking on the check box assigns the value and turns on the check mark.

If the field is already 1, then clicking on the check box deletes the value and unchecks the box.

Can someone provide me with the vba code that makes the check box operate correctly? I appreciate your help.

Thanks,

Jeff

View 1 Replies View Related

Check Boxes

Sep 28, 2004

Is there a way to make sure that one of two box is checked. And if one is checked the other could not be. For example. If I have a check box called Father and one called mother. If father was checked Mother could not be checked, and visversa.

Thank You

J

View 3 Replies View Related

Check Boxes

Apr 11, 2005

If a check box is true/checked, how do I make it invisible on a report?

Any help is greatly appreciated.

Filipina

View 1 Replies View Related

Check Boxes

May 4, 2006

I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together.
When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does not work. But if I leave them click the report will work. Basically what is happening is when I unclick them, the lose their value.
I have the check box set up with a Default Value as "09" or "10" base on what Grade Level there is.
So my two questions are, how do I keep the value of the check boxes after I unclick and click again and Secondly, is there a way to have the boxes unchecked when I run the program?

View 1 Replies View Related

Check Boxes

Feb 5, 2008

I have a column which are check boxes to indicate whether plants are available for sale or not. The problem is how do i put code or symbol in to check all boxes or to uncheck all boxes.

View 4 Replies View Related

How To Count Check Boxes??

Jul 14, 2005

I have a table that contains the following fields:
township
male - yes/no
female - yes/no
number of kids

I need to create a query that will give me the count of males and females and sum of number of kids - all grouped by township.

I have created 3 separate queries that calculate each part and they work. My question is how do I display the results of all these queries in one report, all grouped by townships?

Or if there's a way to create one query that will add all of this up? when I tried to create one query, the check boxes were not calculated properly, because Access did not distinguish between filled and empty checkboxes and would just count them all...

Any ideas or suggestions would be really appreciated.

View 11 Replies View Related

Count Up Check Boxes

Jul 29, 2007

I was just wondering if there is any way that I can create a query to find all of the records which have a tick box checked.

There is a tick box on each form and I want to know what I type in the 'Criteria' box is Query Design so that I can quickly and easily search for all those which are checked.

I know that in a normal query, to search for a particular object you can type it in (e.g. 'Mugs' - will find all the records under the name of 'Mugs' when typed under the right heading) but i'm unsure of what to type in under the 'Target' heading to make it find all those which are checked.

Any ideas. . .

View 2 Replies View Related

Yes/no Check Boxes In Query

Sep 19, 2007

I have a form I am creating from a query that has numerous yes/no checkboxes. I have been able to enter over 2/3rds of the yes/no boxes. However, I'm trying to enter the last of these into the form, and they suddenly change to text boxes. When I go back and check the query, they have also changed to text boxes there as well. I've checked and re-entered the data from the table to the query and finally to the form again. Same thing happens everytime. Any idea what's going on here?
Thank you ~

View 1 Replies View Related

Check Boxes On A Subform

Aug 19, 2005

Good Day Everyone :)

I appologize that this may be a very remedial question, and that many previous threads pertained to the general topic of check boxes, but as I am new to the world of access, I did not find any threads which i could apply to my following question.
I would greatly appreciate any help and guidance :)

What I am trying to accomplish is to set up a subform in which each record is linked to a check box. The check box would be used to select unique records for an upcomming search.
My problem: the check box which i have added to the subform (from the toolbox) is linked to all of the records. That is to say that when I check one box it checks all of the all boxes as well. :eek:

Is there any SQL language which i should be applying here?

Suggestions are much appreciated :)

Thanks a million in advance,

~ N' Take care ~ :)

View 3 Replies View Related

Check Boxes On A Form

Jun 1, 2006

Hi All,

I have a form with a series of check boxes (see image below). The check box is always in the top left had corner and is very small. Does any one know if it is possible to:

a. Have the check box in the centre
b. Enlarge the check box, so the tick itself appears larger

13770

Cheers,

Aaron

View 9 Replies View Related

Speaking Of Check Boxes

Jul 13, 2006

what if i dont want a user to be able to select check box 2 if check box 1 isnt select

View 7 Replies View Related