Composing Filter Using Checkboxes
Jul 26, 2006
heres what im trying to do
i have a main form that displays medical patients information from my table GENERAL, and then from REFMD, DIAGNOSIS, ENCOUNTERS, and MEDICATIONS as subforms.
i have a smaller form named multiple that has checkboxes with the values State, Zipcode, Diagnosis, Medication, and RefMD.
when say state and zipcode are selected on this form and submitted, i need to prompt the user for those 2 values and then filter the main report with the relative query.
i can do it with just state and zipcode, but i cant figure out how to include the subforms in the query, like diagnosis or medication
can anyone help?
View Replies
ADVERTISEMENT
Mar 19, 2008
Hi Folks.
I have a select query that has 10 columns which are checkboxes (yes/no) from the original table. I can apply filters for individual columns but I want the query to show records with ANY of the boxes checked and only omit those with NO boxes checked.
I have spent the whole atfernoon researching the forum but I can't find what I need. Help much apreciated.
Chalkie.
View 1 Replies
View Related
Jul 26, 2013
I wish to filter the records in a listbox by using checkboxes.
The listbox (list1) and the checkboxes are in the same form (form1)
The listbox displays the records from a query (query1) related to a single table (table1).
Each record (assuming a list of videos) has a field called "Typology". The "video typologies" are: Movie, Documentary, Animation. So the table1 has a column called "Typology" which displays one of the three typology in simple text.
When entering a new record (in a specific form) user can choose the typology selecting an option in a combobox. The combobox is a "value list" one and I wrote the typologies in the "row origin" line:
"Movie";"Documentary";"Animation"
So we have a single column in simple text for all the typologies, but limited choiches.
So far everything is working well.
Now I wish to filter the records in the listbox by typology. Each typology should be related to a checkbox, so when I check a checkbox then the listbox returns only the records form a specific typology. Also, I wish to check more then one checkbox in order to display records from multiple typologies rather than one.
I've already made a button which resets the form, displaying once again all the records and eventually unchecking all the checkboxes.
About option buttons: I've managed filtering the listbox results using option buttons in a frame (option group?) and it works fine, but in this way I can choose only one typology at a time (and the typology field in the tabel1 of course is not simple text, but numeric: 1=Movie, 2=Documentary etc).
I thought this could be solved using the click event on each checkbox:
-If the checkbox "Movie" is checked then the listbox shows only the records which have the text "Movie" in the Typology field. Else, show all the records.
-If the checkbox "Documentary" is checked then the listbox shows only the records which have the text "Documentary" in the Typology field.
Etc......
View 11 Replies
View Related
May 7, 2015
I have a form where you can select four different options: Health, Dental, Vision, and COBRA, with a button to run a census. Right now, the button runs a DoCMD.OpenReport to open a report named "Census" where there are four text boxes, "Health Coverage Type" "Dental Coverage Type" "Vision Coverage Type" and "COBRA Coverage Type". I want the user to be able to select a checkbox, then filter the report to only enable the text boxes of the corresponding names.
So if someone selects Health & Dental, I want the report to run with the "Health Coverage Type" and "Dental Coverage Type" textboxes enabled/visible, but the other two to be blank.
View 1 Replies
View Related
Jan 20, 2006
Any idea how I can display this information a lot neater?
Its a bunch of check boxes (I wasn't sure how to go about doing this without them, as they can choose multiple things, if it was just 1, I would have used a dropdown).
I've been trying to fiddle with this for a while now with no good ideas coming to mind.
Anyone have any ideas or examples of how I could go about this?
Thanks
View 4 Replies
View Related
Jan 14, 2007
I am trying to use check boxes as a yes/no answer about whether members have completed training modules, and bind them to a table.
I get this error when tick the boxes, and try to close the form; "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)"
When I reopen the form the check boxes are greyed out until i tick them (not getting values from table) :confused:
Any help appreciated :confused: :)
Matthew
View 1 Replies
View Related
Apr 11, 2007
I have a form that uses checkboxes to list all the fields in a table. How would I create a query based on that form?
For example -
Field Names - RMA_Num, Qty, Date_Rec, Part_Num, Desc, CC_Primary, CC_Secondary, CC_Tertiary, OF_Appearance
A user may choose to see Qty, Part_num, CC_Primary, CC_Secondary, and CC_Tertiary. How would I set up the query?
For testing I tried having RMA_Num, Qty, and Date_Rec in a query. I set the criteria for RMA_Num as IIf([Forms]![frm_meta]![Check0]=True,[tbl_Mfg_RMAData]![RMA_Num])
With the box checked the query will return results for all the fields. But if the box is unchecked the query returns nothing.
View 3 Replies
View Related
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 10 Replies
View Related
Dec 14, 2006
I have form, with a number of orders on there, i wanted to be able to give the user the option to select all the orders and update each record, however when i give the user the option to seleect all the orders on the first line is updated. how can i get all the records to be updated the code i am using is shown below, any help will be greatly appreciated.
Dim db As DAO.Database
Dim String2 As Integer
Dim i As Integer
Dim rs As DAO.Recordset
Dim StrSQL As String
Set db = CurrentDb
Set rs = db.OpenRecordset("kell")
For i = 1 To Me.Quantity
Stringy2 = InputBox("The Cylinder/Cylinders Will Be with the driver
from The Specified Date Below:-", "Spec Gas 2006, (DD / MM / YY)", Me!Text68 & "")
If StrPtr(Stringy2) <> 0 Then
rs.AddNew
rs![Line Number] = Me![Line Number]
rs![Time of Transaction] = Me![Transaction Date]
rs![Cylinder Barcode Label] = Me![Cylinder Barcode Label]
rs![Cylinder Number] = Me![Cylinder Number]
rs![ProdNo] = Me![ProdNo]
rs![Status] = Me![Status]
rs![AberdeenWONumber] = Me![AberdeenWONumber]
rs![Works Order Number] = Me![Works Order Number]
rs![CustNo] = Me![CustNo]
rs![Customer Order Number] = Me![Customer Order Number]
rs![Date of Transaction] = Stringy2
rs![User name] = Me![User name]
rs![Employee ID] = Me![Empoyee ID]
rs![A Number] = Me![A Number]
rs![New Status] = "With Driver"
rs![Date of Transaction] = Me!Text68
Me.Text71 = "With Driver"
Me.Text71.ForeColor = vbRed
Me.Text74 = Me.Text68
rs.Update
MsgBox "The cylinder is now with the driver", vbInformation, "Returned Successfully"
End if
Next i
rs.Close
db.Close
End Sub
View 2 Replies
View Related
Jan 7, 2005
I have a database which uses checkboxes, however I only want my users to be able to select one or the other, not both.
How do I disable the second box when the first one is checked?
Thanks in advance
Kat
View 2 Replies
View Related
Jun 6, 2007
Sorry, but this is killing me. I can't find anything in the archive which directly relates.
And it's complicated. I'll try to simplify.
In a nutshell:
As I scroll each Employee on a Parent form, I'd like a subform with functionality to check off any Certifications earned by this person and write the EmployeeID and CertificationID to a junction table.
Seems to me it should be simple, but...
Anyway, here is the probably overcomplicated version here:
The one side tables are 1. Employees and 2. Certifications
The junction table records which certifications employees possess. This table contains some Boolean fields.
The Parent form knows the EmployeeID.
My goal is to create a subform on which to display the full list of Certifications, something similar to the attached image, with a button to add an EmployeeID to the junction table AND tick off the Boolean checkboxes.
I've based the subform on a query showing ALL Certifications and all (Junction) records where there is a match
Because the junction table only stores related Employees and Certifications as entered, the checkboxes on my subform cannot be bound directly to the fields in the junction table and, at the same time, allow me to check off the Booleans.
Perhaps a little db redesign? Any help greatly appreciated.
View 2 Replies
View Related
Mar 15, 2008
Let me just start off by saying, I don't have any code to post as it is just an idea I have.
This is a Lease return project for work. We have an excel sheet that is broken up into tabs. Master List, Not Returned and then a tab for every month.
Here is what I would like to do.
If someone checks the box that says the leased computer was not returned, can I grab a certain batch of fields to automatically populate another Tab in this Access 2003 Form?
The second part to this would be if a person unchecks "Not Returned" in the Not Returned Tab, can I get that record automatically removed from that list view?
Similar principle for the Monthly shipping by a certain date. If the user enters in a shipped Date by say March 1, is there any way to populate a another tab into a list view?
Thanks for any advice that you gentlemen and ladies can provide.
View 14 Replies
View Related
Jan 3, 2006
i have checkboxes on a form and want to run a query based on the amount of times the checkbox(es) have been selected...
i have done this and attached a report however because the value of the checkboxes is -1 obviuosly the sum of this is a negative number and so on the report the total selcted is negative....
is there a way to change these to positive numbers...
and if so where do you put it.
cheers in advance
Si
View 6 Replies
View Related
May 22, 2006
The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated.
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:
=iif([ItemA]=True,0.33,0)+iif([ItemB]=True,0.33,0)+iif([ItemC]=True,0.33,0)
This will add these three items up and give you the percentage. You can also do the same in a query to based your reports on these percentages.
Yet, It isn't working properly. Any ideas?
View 3 Replies
View Related
Jan 22, 2005
I am new to Access coding. I'm trying to do the following in Access 2000.
I have a form which includes some tabs. On one tab I would like to display a list of items from an Access lookup table with a checkbox next to each item. The list needs to be drawn dynamically from the table since the table contents can change. I tried using the subform/subreport control with a querry as the source object but the display is not very nice. Basicly I want the tab to look like the picture enclosed but dynamically drawn from the values in the lookup table.
Any help would be greatly appreciated.
Thanks
Sue
View 2 Replies
View Related
May 22, 2006
The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated.
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:
=iif([ItemA]=True,0.33,0)+iif([ItemB]=True,0.33,0)+iif([ItemC]=True,0.33,0)
This will add these three items up and give you the percentage. You can also do the same in a query to based your reports on these percentages.
Yet, It isn't working properly. Any ideas?
View 8 Replies
View Related
Sep 2, 2006
I am very new to Access, so bear with me please.
How do you create a form that will query a list from a table, and then separate each invidivual entry from the query into its own checkbox?
Example:
*run query or something similar, and 3 items are brought up*
Tracking Form 00001:
Item1 [x]
Item2 [x]
Item3 [x]
Each individual item in the query might change, so I want to keep it flexible. Once all of the checkbox options are organized and put onto that section of the form, I want to append all of the values that were checked off into a field on another table. So for example let's say the person inputting the form checked off item1 and item3, the field on the table linked to it would now have field1="item1, item3".
Is there a way to do this without a lot of coding, possibly just using the menu-driven interfaces and maybe a coded query? I am not that familiar with Access so any help is appreciated.
View 2 Replies
View Related
Jan 7, 2005
Bit of a novice here...please help!
I have a table listing product # follwed by 12 different bullet points (all text fields). Each bullet field has a corresponding checkbox field stating whether that item should be deleted or not before it is posted to the server. If the item is marked for deletion, the next bullet point needs to move over to the field, leaving no null fields for the final result. Following? I hope so. In addition, some of the bullet fields are currently null and need to be deleted as well. I'm pretty good with designing select queries and basic stuff and I know a little SQL, so any help is greatly appreciated.
View 1 Replies
View Related
May 26, 2005
How do you count how many times a checkbox has been checked?
learnasugo
View 2 Replies
View Related
Jun 18, 2005
Is there a way of putting the checkbox to the right of the text other than dragging it over?
View 1 Replies
View Related
Aug 22, 2004
Hello,
I am rather new with Access.
Basically I have a empty checkbox that when someone checks it (or it becomes true), I want the current record to have certain fields saved to another table and then I want the current record to be deleted.
Could someone show me some code on how to do this?
Thanks in advance.
---Dave
View 1 Replies
View Related
Jan 16, 2007
Hi everyone!
The backstory: I've recently started a new job and as such now have responsibility (with no handover of any kind) for someone else's very very messy Access database that has bandaids upon bandaids. And I don't know that much about Access LOL. I thought I knew enough to get it to do what I wanted, but apparently not.
So, I'm trying to add a checkbox to a continuous form. I've added a Yes/No field to the database and made sure all the records are populated in this field. The checkbox I've added to the detail section of the continuous form is bound to this field.
Now the problem - when all the records are displayed in the continuous form, all the checkboxes show grey-ness. And you can't click on them - it says "Control can't be edited: its bound to an unknown field". But the field is definately there, and there are no typos. It doesn't even have to be editable in this form (although that would be handy), it just needs to show one way or the other!!
I know that the field works because I have a checkbox on a different (non-continuous) form bound to this field and it works fine there.
Anyone who can help me fix this problem wiill have my eternal gratitude :P
View 1 Replies
View Related
Mar 14, 2006
This is for anyone who has made a form with a lot of check boxes and wants to make a report out of them thats decent.Hopefully this simple example file is enough to assist people.Keywords:Checkbox Checkboxes report check boxes box
View 1 Replies
View Related
May 17, 2006
I am currently building an Access database. I have built my tables, queries, forms and reports. On one of the forms, I have checkboxes with headings on them; ie: Project Complete. Yet with each heading I want to assign a value. Then the values for each heading will be added per database entry, to give me the total percentage of project completion. Can I do this with check boxes or radio buttons?
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
:confused:
View 8 Replies
View Related
Aug 28, 2006
Hi,
i have created a table that would calculate the total payments that are being made by a certain contractor. I am assuming that the contractor pays the money in three installments.
In a table I have created three fields which are all checkboxes that would state whether a payment has been made or not, for example, checkbox1 would state whether the first payment has been made. And I also have three other fields that states the amount to be paid on each installment
Now, i want to calculate the total amount that have been payed. For example, lets say that the first installment has been made (i.e the checkbox is checked), then the first payment should be added. And if the second payment has been made it should be added as well, thus finally giving the total amount that has been made.
I know how the logic should look like, but i just don't know the syntax that i should use in the query.
Thanks.
View 1 Replies
View Related
Nov 22, 2006
I would like to know how to properly use checkboxes in a form as criteria in a query. Specifically how to get an iif statement to evaluate whether or not a check box in a form is checked
Take a very simple example of a database containing a employees of two types. Two tables exist; an employee table, and an employee type table.
I then want to make an easy to use interface for getting a query of employee information for one or both employee types.
I figured that the best way to do this would be to create a form with a checkbox for each type and then create a query that uses an iif statement like this:
IIf([Forms]![employee_type_query_frm]![Check_type1]=YES,"1",Null) Or IIf([Forms]![employee_type_query_frm]![Check_type2]=YES,"2",Null)
Where one is the number associated with employee type 1 and 2 is the number associated with employee type 2.
Then I just build a simple macro in the form to run the query. This way someone who doesn't know how to work in the query interface can open the form, click the checkboxes for the type of employees that they need information on and run the query by pressing a command button.
The problem is that I don't know/can't find the proper syntax for getting the iff statement to evaluate if the checkboxes in the form are checked or not.
If anyone could give me some advice it would be very much appreciated.
PS: here is the full SQL of the example Query
SELECT employee_tbl.[employee#], employee_tbl.employee_name, employee_tbl.employee_type
FROM employee_type INNER JOIN employee_tbl ON employee_type.employee_type = employee_tbl.employee_type
WHERE (((employee_tbl.employee_type)=IIf([Forms]![employee_type_query_frm]![Check_type1]=1,"1",Null) Or (employee_tbl.employee_type)=IIf([Forms]![employee_type_query_frm]![Check_type2]=1,"2",Null)));
View 3 Replies
View Related
