Search results for query: listbox selected items

  1. oxicottin

    Solved Move selected to top of listbox

    I have a multi select listbox which is a long list, so I wanted to move the selected items to the lists top, so I won't have to scroll through the list upon reopening the form.
  2. C

    Solved FAYT Listbox Tab

    Ok... this is in reference to a previous post but that problem was solved so I'm starting a new one. I have a MAJP listbox popup form. On open the focus is set to a txtbox for typing in a search text. Before anything is typed in, you can tab to the list box. After anything is typed in you cannot...
  3. Luis Fernandez

    Solved Listbox AfterUpdate and click when there is no selection

    I have a problem that, although I haven't thought about it much, I don't think I see an easy solution. In a multiselect lisbox when I click with the mouse and select an items/row, afterupdate and click are activated, but when I use the down arrow and I only position myself (not selecting) the 2...
  4. oxicottin

    Solved Multiselect listbox loop showing there isn't data

    Hello im looping controls on my main from from my subform and I have one issue "So Far". I have a multi select listbox on my main form and the code below is saying there isn't data in my listbox because when ran it highlights it and there are several items selected so there are things there...
  5. AOB

    Can't deselect item in non-multi-select listbox?

    I'm embarrassed to even ask this question but for some reason I can't figure it out... Very, very simple problem - I have a ListBox that has Multi-Select set to None (i.e. only allow one item to be selected at any time) When I select an item, I can't seem to deselect it again? I can only...
  6. Minty

    Solved Move selected to top of listbox

    The other option would be to store the selected items in a separate table and reload them on form opening. I would use two listboxes, one you select from (the current list) and second one with the selected items in it, and have command buttons to move from one list to the other and vice versa...
  7. N

    Deleting multiple items from a listbox

    Hi all In continuation of this thread, I am looking to have similar function where I can select multiple values and delete them at once, rather than deleting each value individually. My listbox is bound to a table, and as such row source type is set to table/query. Here is my code: Dim i As...
  8. MajP

    Button to Select All and Delete selected items in a List Box

    See if this is what you mean As written originally this code does not make logical sense Public Sub AddRemoveSelections(lst As Access.Listbox, JunctionTableName As String, KeySelectField As String, KeyFilterField As String, FilterKeyValue As Long) Dim FocusedItemIndex As Integer Dim...
  9. isladogs

    How to highlights the current record on listbox

    Sorry. I've only just seen this thread The selected item in a listbox is automatically highlighted. No code or action needed! For examnple However it higlights all field in that listbox record Am I missing something in the question asked?
  10. E

    Solved Listbox AfterUpdate and click when there is no selection

    Based on this, a multiselect listbox is not the best idea, you could use a transfer box design, where you basically select something in listbox 1 and it appears in listbox 2. That way your users will know the order in which things will be executed. There is no built-in way to know in what order...
  11. Gasman

    Solved Two listboxes remove selections if used

    You need some sort of flag in the employee table to indicate which list box they should appear in. When you select one, you set that flag or clear it and requery both listboxes. That is one way that I have done it. You really should try searching, even here...
  12. MajP

    Button to Select All and Delete selected items in a List Box

    Your question was pretty confusing if this is what you mean. Your code is not even referencing the correct listboxes and it is looking at items selected and not the items added to the assigned listbox. The code does not even seem to be attempting to do this, if is what you are asking...
  13. arnelgp

    Solved Move selected to top of listbox

    ..so you only want it to be ordered (ordered by selected first, then the rest) when the form opens. you can change recordsource on the current event of your form. Private Sub Form_Current() 'Uses module mod_MultiListbox Call ClearListbox(Me.lstDefects) 'Clear the listbox If Not...
  14. MajP

    Button to Select All and Delete selected items in a List Box

    This solves the immediate problem, but unsure if it solves the bigger issue. Your add procedure has no error checking, and it will always fail if you pass a listbox that has no values selected. Public Sub AddRemoveSelections(lst As Access.Listbox, JunctionTableName As String, KeySelectField As...
  15. I

    Solved Click on listbox item and requery report on subform?

    Hi, I have a form with a subform. On this subform i have a report and a list box.I want to be able to click on the listbox item and then display the record details in the report. I have tried this code: DoCmd.OpenReport "Report", acViewPreview, "[ID] =" & lst_Items.Column(0) but because the...
  16. MajP

    Solved FAYT Listbox Tab

    Thanks these are good suggestions. See if this version is better. In the initialize you have to also pass an additional parameter. You will have to modify your current call to initialize. UnselectOnFilter: yes no New behavior 1. The lisbox does not select a value when filtering until there...
  17. theDBguy

    How to highlights the current record on listbox

    Do you mean like "select" that item on the ListBox?
  18. June7

    Solved Listbox AfterUpdate and click when there is no selection

    I changed my listbox to Simple multiselect and tested AfterUpdate event. It is triggered when cursor moves through items, even if I don't click into listbox - I click on scroll bar then use cursor keys - no item is highlighted, just dotted line around current item line. The AfterUpdate event...
  19. Ranman256

    Solved Combo Box to populate multi-value field in many-to-many relationship

    combo box is for 1 item. Do use the listBox ,but put a text box above it to filter down the listbox: If IsNull(txtFilter) Then lstBox.RowSource = "qsAllNames" Else lstBox.RowSource = "qsFltName" End If 'qsFltName sql would be like: 'select * from table where [LastName] like '*" &...
  20. Luis Fernandez

    Solved Listbox AfterUpdate and click when there is no selection

    Oldvalue did not work, since the items do not have oldvalue, only the control and the listboxes always return null to value and oldvalue. I think I will have to do everything manually, that is, I will memorize each selection value of each item and then compare them to see if they have changed...
Top Bottom