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!
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.
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?
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.
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.
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!
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?
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:
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.
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 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"
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.
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.
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...
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:
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.
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:
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.
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.
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?
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