combo

Hello All, First time posting. I am only a beginner with VBA. I have a number of active x combo boxes and they are firing the vba when the list source changes. Can anyone help on how to stop this happening? This is what I currently have to try and stop but is not working. When you click...

Hello, Hope all are well Hoping you will be able to help me out on this one.. I'm creating supplier / customer database and I'm building "Update" button. Basically I have the table of customers / suppliers and some of them are duplicated. For example I have a company who deals with the...

Hi, Ive only been working in Access for a week so please be gentle :) This will probably be a silly question but here goes..... Im trying to create a search filter using a combo box in my access form. I have a table with multiple records. One of the table fields is called 'report type'...

I want to open embed file in excel via userform combo box value.. Please help..

I have a Field on my form that's a combo box. It defaults to "*". When the user makes selections or leaves it at "*" the value is used as the criteria in a query. My problem is that sometime the User will delete the value in the Combo box and then run the query. this ends up showing no...

I have a Split form based on a query. In the header I added a Combo Box. I use the Combo Box selection in the criteria of my query [Forms]![frmQuoteStatus]![Combo84_BidStatus] If I go to my query and refresh it runs the query and limits the results as it should. my problem is with my form...

Hello, I have a problem statement. I need to filter data based on specific characteristics. So characteristics is in column 1 ( A24:A258). I need a method and code to add a separate activex control so as to filter the data based on these characteristics. The problem I am getting is I have 3...

I have been trying to get my combo box (cboARNumber) to update fields in the form "Plan Details" which include: ARNumber AdviserName AdviserSurname AdviserPractice DealerGroup Mobile Email It should be straight forward and worked when I did it on my first record but won't work on new records...

Hi I want to update table's field based on combo box selection, all table fields are on same form of combo box. for example if i select employee ID 1 in cboEmpID than all his details and text boxes or combo boxes field on form should change to this employee's information and this information...

I added a filed on a form that is used as the filter Criteria in a query. The field is a Combo box. Like [Forms]![Open Bids]![FilterByPricer] After I change the selection in the Combo I have to click the "Refresh All" in the ribbon in order for it to update the records in the form (Which are...

Hi People. I want to enter a value into a combo box on a webpage. I can access the combo box no problem and enter a value. ... my issue is the value is a date and needs to be entered in a certain format which is dd-mm-yy. However as this range changes on a daily basis i cannot put...

Hi All, I am not entirely sure how I should go about accomplishing this because I believe there are a few ways to do this. I have a list of data similar to below: 0582 051 0582 954 0582 725 1275 654 1275 777 5290 936 5290 003 5290 051 5290 923 5290 000...

Does anyone have any code that will give me the row value of a chosen item on a combo box?

Trying to find a formula to seach a range of combo box cells for a word and display a text in another cell. Example... (Combo Box Cells) A1: John Doe - EMT A2: Jane Doe - Paramedic A3: Pizza Dough - EMT Need a separate Cell, lets say B1 to contain "ALS" for Paramedic or "BLS" if the list...

On my userform I have two combo boxes and one read-only textbox. In the first text box the user selects a machine production line. Based on the machine production line selected, the second combo box will populate with the products that are ran on that line which is located on a spreadsheet named...

Private Sub cmbSDPFLine_Enter() Dim i As Long cmbSDPFLine.Clear cmbPrdCde.Enabled = False cmbPrdCde.Clear txtbxPrdctNm.Text = "" WS_Count = ActiveWorkbook.Worksheets.Count For i = 4 To WS_Count cmbSDPFLine.AddItem Sheets(i).Name Next End Sub...

I have a userform with a combo box where you can select various models of valves. Depending on what model you select I would like another combo box to appear which is linked to a named range. There are 6 different model number to chose from so I need 6 different combo boxes to appear & 1 free...

How would one go about inserting column data into a worksheet combo box and remove duplicates? also the list of data will vary. Thanks

As of now I have two tabs labeled hats and shoes. The first combo box displays in this case Hats and Shoes. Private Sub cmbSDPFLine_Enter() Dim i As Long cmbSDPFLine.Clear cmbPrdCde.Enabled = False cmbPrdCde.Clear txtbxPrdctNm.Text = "" WS_Count =...

Don't know if this has been answered in the past. But I'm trying to pass a value from a combo box into a query criteria. There is one issue though, I'm trying to get the values of yes or no into a > 0 value into the criteria value. For example, if someone chooses "yes" in the combo box it...