Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.
Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.
I have a user input form to enter traffic counts. There is a subform within that form that shows the total. I want to have a check box which, if checked, will multiply the data in the box by two. I have tried building expressions, macros...nothing worked. Dont know what I'm doing wrong. Any idea?
View 9 Replies View RelatedI have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc).
I am trying to get the report to read the status and check the appropriate box in the report.
I have tried this in the control source of the checkbox
=IIf([status]="terminated";True;False)
but this does not work
I have also tried this on the OnOpen
If [status] = "terminated" then
termcheck = true
else
termcheck = false
end if
end sub
But this does not work either - what am I doing wrong :confused:
I have created a user form that contains check boxes for various fields, and on this form, when the box is checked, I get a prompt that the field cannot be updated. I have several other forms that use these same yes/no fields, and I am not having the same problem on these forms. I checked the property sheet row source for the form and I don't see anything wrong with the select statement (that I know of).
View 1 Replies View RelatedI am trying to create a medical records inventory. We have physical charts which each have a barcode and I have a scanner. The idea is to have employees who want to check the chart out scan their barcode (on their badge), scan the chart's barcode and leave.
I have a table called tblCharts with the fields: ID (primarykey which is also the chart number), a checkbox, Employee ID, Date, and Time checked out.
I have Employee ID linked to my tblEmployees that simply has a listing of the employee ID's and first and last names.
I don't care about keeping a record of who has had the chart in the past.
I just can't figure out how to tell the checkbox to be checked (to indicate the chart is out) when a number is added to the ID field (via scanner).
So here's how it would go:
Scan the chart's barcode which would populate into the ID field. Search to see if the record with the same number is already existing, if not create a record. IF it does exist, check to see if the checkbox is checked. If it is checked then the chart is being checked back in (so uncheck the box). If it is not checked to begin with (still in), then check it out and associate the employee's scanned barcode with it.
Dear All:
I posted this question before but I did not include the right information. (Many thanks, Mwalts)
I have created a form with checkboxes. I wish to export data to excel on only the people that are checked.
To export is not the issue. I have created a query to list only the people that are checked. The control souce of the checkbox is called graduated. When I go into the datasheet view, the people who are checked are represented with a -1.
In regards to the design view of the query, what text or value do I place in the critera field to list only the people that are checked?
Any help is greatly apprciated.
Regards,
Dion
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.
I have kept the names as simple as I can for the example sake to which I can substitute my names in after.
I have a split form - form1, I have a check box on this form - checkbox1 - That I would like to use to make only the checked results from the table - table1 - show and if it is not checked to show all the results. How would I go about doing this? The table field is called field1.
I have a table listing xxx reasons for dispute - Users will check boxes. How do I build my query that would list all the entry numbers which have a text box?
Might sound stupid but what would be the criteria? Think it would be easier to get these results into a report and sum.
I'm baffled!19142:confused:
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 RelatedI 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]...
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.
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 RelatedHi,
I was wondering how to delete records that have been checked (through a checkbox) in a form...
Also, I want to add a record after the record that has been checked. I only want this ability to add records available if only one record is checked. Otherwise, if more than one record is checked, the "Add Record" button would be disabled.
Any help would be much appreciated.
TIA.
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
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 RelatedThis 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
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
If a check box is true/checked, how do I make it invisible on a report?
Any help is greatly appreciated.
Filipina
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?
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 RelatedI 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.
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. . .
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 ~
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