Forms :: Checklist Database - Disable Combobox List After Use It
Jul 15, 2014
I am doing a checklist database.
With some other data, i have a field called "Local". (combobox)
In that "Local" field i must select the place where the checklist is made.
So, i have 20 places to do checklists, and when i select one place and save the check list, i need that "local" is disable from my combobox list so i dont accidentally repeat it.
My combobox is based in a table query.
I must do 2 checklists per day for each those 20 places...
And i cant figure out how to remove those items after use them at the morning... and have them available again in the afternoon.
I have a combobox with a value list as the control source. I have a user who clicks the drop-down, but there are no options. Every other user is able to view these options, and this user has no problem with any other combobox with a value list.
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list.
I have a basic form linked with a subform inside of it. The main form has a list of customers in a combobox and the subform lists all the things they have ordered from us. This all works perfectly fine, I can add data to the list of things ordered and it's ok.
I decided instead of using a whole extra form to add customers I'd just have a not in list event and allow users to add customers through there, bit more intuitive and cut down on forms.
It works to certain extent except one small problem, if I add a customer I have to close and reopen the form to be able to add/remove data from them in the subform. If I leave the form open and try to enter in data in the subform immediately it just shows whatever customer I had last on the combobox and adds it to the last customer as well.
It works perfectly fine if I reopen it so I thought it was some kind of query or update snafu but all the VBA code examples I found don't seem to do anything. Not exactly sure where to go from here.
PHP Code:
Private Sub cboDept_NotInList(NewData As String, Response As Integer) Dim oRS As DAO.Recordset, i As Integer, sMsg As String Dim oRSClone As DAO.Recordset Response = acDataErrContinue If MsgBox("Add dept?", vbYesNo) = vbYes Then Set oRS = CurrentDb.OpenRecordset("tblDepartments", dbOpenDynaset)
I have a database that is used to generate quotations. I have a form that I want to use to Re-Quote something. By Re-Quote, I mean I want the employee to be able to go in and search for the Part desired for Re-Quoting and create a new quotation with all of the information from that part and have the ability to change any of the information as needed. The Form is unbound, and has tab control with three tabs. I would like to search by three different categories "QuotationNumber", "Customer", Or "PartNumber". How do I have the combobox filter the list box below based on what is being typed in the combobox?
I have a data base with names, email IDs, phone numbers of 5 types(example quality, security, IT,finance etc) of person from ten different project teams. I created a basic form for the end user to enter values and created fields for each of the person's name, email ID etc based on the personal type( liek quality, IT, finance etc) on each team. The background table contains records of almost 200 people now.
All of these people will be trained for one task and some will be trained for multiple tasks. I know how to make the combo box allow multiple values/selections but, i cannot list out all 200 personal names in the combobox's rowsource/value list. Is it possible to combine all different name fields and list out all personal(of one team), so that the end user can just select multiple names for that team who have been trained and so on. i need to set the rowsource of the combobox to the values of all personal from one team so the team leader can just go select who has been trained and who has not.
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.
I would like to select a record from my combobox dropdown list and have that record populate in my subform. Currently, I am only able to select the 1st record at the top of the dropdown list to appear in my subform. But I would like to select any record from the dropdown list and have it populate my subform.
Hi - I am an Access newbie. I would like to use Access to develop a checklist that uses a two dimensional parent table (with row and column titles) that, when a check box is selected in a given row/column location, a specific sub-table is displayed. Likewise, when certain conditions are satisfied on a given sub-table by clicking on a check box(es), I would like to indicate the status with color and/or text in the associated row/column location on the parent table. Any ideas on how to accomplish this would be greatly appreciated.
I have done 5 videos (total running time -about half an hour) demonstrating how to add a checklist to MS Access.Here is a link to a YouTube Play List of the 5 Videos..Automatically add a Checklist to MS Access
So I'm trying to set up a Tabular form as sort of a checklist
Example Step 1, Step 2, step3, etc etc etc
I have the form setup with 4 tabs or 4 seperate forms within 1 form (works nice) now I trying to set up my query to open the form and I have 3 tables linked to the form. see bitmap
When I add the 3rd table to the query my forms opens to a blank screen no pages and no fields ....
I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.
Code:
Private Sub Manufacturer_AfterUpdate() If (Me.Manufacturer.Value = "Siemens") Then Me.Model.RowSourceType = "Table/Query" Me.Model.Recordset = "SeimensTable" Me.Model.RowSource = "SELECT Model FROM SeimensTable" Else If (Me.Manufacturer.Value = "Samsung") Then Me.Model.RowSourceType = "Table/Query" Me.Model.Recordset = "SamsungTable" Me.Model.RowSource = "SELECT Model FROM SamsungTable" End If End If End Sub
But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?
how do i make 2nd combobox list based on 1st combobox list, mean if i choose A at 1st combobox, only A1-A5 option appear, and when i select B at 1st combobox, only B1-B8 appear to select at 2nd combobox..
I have a form with a subform in datasheet view with a combobox on it. When a user presses the Arrow to dropdown the menu it will stick on the screen after they leave the field. Any idea's?
In a report using a query with a field named: "plantno" and as criteria" :Like [Fill in the plantno] I can put in a plantno.That is working Oke! I want to do the same thing as above but then that i want to see a combobox with a few plantno,s which are put in a valuelist,so that i dont have to type in plantno,s but that i only can choose out a valuelist.
I have a secure MS Access database, where users by default can only read data, but not write. How can I prevent them from importing or linking files, or inserting objects? I don't want to use any passwords in my database, since it's used inside the application. Thank you.
I created a database that uses the "lngEmpName " number to give user permissions , what I need is to be able to disable the running of the database (or main form)and show an error message using vba if I have not logged in for around two weeks is this possible ? if so how and even better a demo would be fantastic.
Is it possible to alter the values displayed in a combo-box dropdown at run time. I tried using the following bit of code in a listbox's 'After Update' event , but it does not alter the combo-box's value list.
dim strSponProjStatus as string dim StrNonSponProjStatus as string
If Me.cboFundingSource = "Sponsorship-ADP" Then Me.cboProjectStatus.RowSource = strSponProjStatus Else Me.cboProjectStatus.RowSource = StrNonSponProjStatus End If
I have a database that uses a switchboard with a close button that runs several instructions before it exits. The problem is that some users have access to the database window and I need to prevent them from closing the database by hitting the X in the upper right.