Search results

  1. A

    multiple selection list box to open query not working

    Hi again everyone! I think I made sense of it all and make it work, so I am going to post the procedure that I made with general names, so maybe it can help anyone facing this same problems in the future. Please be aware that my knowledge on VBA is VERY limited, and there might be a more...
  2. A

    multiple selection list box to open query not working

    Thank you Josef P., My problem there is that the items to be selected by the user depend themselves on the result of a previous query, therefore I can not make a unique design of a form with the multi-value controls (as far as I know). I will keep this on mind for selections of fixed items...
  3. A

    multiple selection list box to open query not working

    I do not understand :( Following your strategy, how can I also incorporate the listing directly into my query? I was only using the textbox to see if the code was working properly and all elements were being selectec but I do not need it at all, I only want that multiple selection to filter the...
  4. A

    multiple selection list box to open query not working

    Thank you for replying. I understand that the filter content was not correctly built, it was lacking the """ to indicate that the elementes selected are texts. I added Char(34) instead of Char(39) since in the Spanish version, text content should be indicated between " and not between '. So...
  5. A

    multiple selection list box to open query not working

    Thank you very much. I am taking a look at it and I think I am starting to understand a few things that might help me... I believe the biggest problem that the database which I need to work on has, is that no numeric primary keys are given to the some tables... Unfortunately I cannot change...
  6. A

    multiple selection list box to open query not working

    Hi moke123, Sorry for poorly explaining myself previously. I have a form with a list box in which I want the used to be able to make multiple selection of values. The name of the list box is CodigoMasa and exists on the form 1_SelectorConsulta. I have created the following code Private Sub...
  7. A

    multiple selection list box to open query not working

    Hi Kath, I know it's been years since you solved this problem, which is exactly the problem I am struggling with at the moment. Is there any chance you could help me clarify your solution? Where exactly did you set [Forms]![frmSelectToExport]![txtSelected] and Like "*" & [fkPlanTypeID] & "*"...
Back
Top Bottom