One Click Selection Of Many Checkboxes
May 28, 2007
Hi! I've got a dousy for you all. I'm hoping that what I'm asking about is 1) possible, and 2) not very complicated.
I have a form that is based on a query that shows all records with a state field of say, New Mexico. I'm using this form to assign a campaign to all of the records that have a Yes in the Append? field of the record (which is populated by me when I run the query). So if there are 10,000 records that fit the state criteria, I don't want to append all of them. I'm wondering if there is a way to highlight (or some other method) them, and click the append checkbox ONCE instead of 5,000 times. I've got the code to select every checkbox, but I don't know how to write to code to only select a certain number of records.
If I have to, I could write an update query that asked for the number of records I wanted to have the append checkbox selected for, but that's a really long way around, and I'm hoping theres a simpler way. I'm sorry I wasn't very clear in my explanation. I hope you can understand and maybe help me figure this out. THANK YOU!
KellyJo
View Replies
ADVERTISEMENT
Oct 19, 2004
I want to clear all the checkboxes in a certain field by using a command button on a form. I could use some help!!
View 3 Replies
View Related
Sep 13, 2013
We have a small lab database where we insert the results of a water plant test. The results can be either Before treatment or After treatment.
And it can be treated numerous times a year.
I have created form with a drop-down box to select the customer and a button to show reports for the selected customer.
But I also want to add 2 check boxes: a Before treatment and After treatment box. And also add a date range.
So when selecting to view reports our users can select a date range example:
01/01/2013 to 01/10/2013 and a check box so users can select if the results to be displayed are Before or After treatment.
View 1 Replies
View Related
Jun 25, 2013
I am currently working on an existing database (not created by me) which contains several queries. Each query relates to a particular product.
I am wanting to create a form which has a combo box so that a user can choose a particular product from the combox options and then click on the command button to run the correct query.
How to do this. I have created the form and the combox (together with the list of products). I just need to know what Event Procedure code I need to enter to programme it to look for the correct query and then run it.
For example.
I have the following queries
product1query
product2query
product3query
I have the following options in the combo box
product1
product2
product3
How do I get the command button to look at the product1 option in the combo box and then find and run the product1query.
View 9 Replies
View Related
Aug 25, 2014
I get a bizarre situation while I am using MS Access 2010 to select values with Combo Boxes on a form, i.e.:
* After I select one or more values from the drop-down list of a Combo Box, there is no response when clicking OK button using the mouse. It is stalled. I need to do the process again and then the mouse-click on OK button could work: click anywhere outside of the combo box, re-select the values, click OK Button, and done.
* However, I can always use Enter key (on the keyboard) upon OK button to complete the selection.
* The values in the drop-down list of the Combo Box were entered manually.
What is wrong with the combo boxes on the form? Why do I need to do twice to complete the selection using mouse-click? Why the keyboard-click ('Enter') can be always OK but not for the mouse-click?
View 8 Replies
View Related
Nov 7, 2006
Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code.
The code below however works for a command button, but not a label button.
DoCmd.OpenForm "frmdatetime"
Do While Forms!frmdatetime!OKFlag.Caption = "False"
DoEvents
Loop
When this code is run by clicking on a command button, it works fine.
If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime.
If I remove the loop with the DoEvents in it, then the problem does not occur.
Can anyone enlighten me as to why this behaviour occurs.
Thanks
Richard
View 4 Replies
View Related
Oct 27, 2014
I am designing a nomination form (web database so no vba macros can be used).
The form has 3 combo boxes: cboStaffName, cboLevel, cboNominee.
The form is bound to the tblSubmit table where the submissions are populated.
I used a select statement:SELECT Staff_List.Staff_Name FROM Staff_List; to populate the combo box for the Staff Name selection.
This is the select statement to populate the job level combobox:
SELECT Staff_List.Level, Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Staff_Name)=[forms]![frmtest]![cboStaffName]));
The select statement to populate the combobox for the nominee combobox:
SELECT Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Level)=[forms]![frmtest]![cboLevel]));
The problem is that the staff_name in the first combobox is still found in the nominee combobox which should not be because a staff cannot nominate self. There is a field in the Staff_List called YesNo that should be activated for each staff that is selected so that the select statement on the nominee combobox can be updated accordingly to remove items with the field "Active"
How to get the checkbox selected for each corresponding staff.
Sample of the database has been attached.
View 4 Replies
View Related
Jan 12, 2005
Porbably a stupid queston for most of you, but I am new to the game. Trying to get the selection of one combo box to filter the selections of a second combo box. Have one table called Sections with the colums SectionID and SectionName, a Second Table called SubSection with Colums SubSectionID, SubSectionName, and SectionID. Third Table called Points which has a column for Section, and SubSection, need to have the section combobox selection filter the SubSection combobox selections. Any help would be appreciated!
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