Search results

  1. DOSPLUS

    Solved Creating combo boxes on the fly

    I do not think so. Once I've parsed the incoming file the value list is the same for all boxes. I create the string for that when grabing initial amount of headings from the excel. I also have to open the form in design view, minimize it, add the boxes, switch to NormalView and then maximize...
  2. DOSPLUS

    Solved Creating combo boxes on the fly

    WOW! Thx to you all for pitching in. I have to admit that I did not mention lots of info because I was looking at ideas and some brainstorming. What i want to do is as follow: 0 - Combo list for selection of which table to update (around 10 table possibilities) But, lets pick one... PART 1 1...
  3. DOSPLUS

    Solved Creating combo boxes on the fly

    Well, I need to create a combo box from vba, not preset. The problem i have is that combo boxes amount will be based on the number of table fields. So, if you were to open the form in design view, you'd see just the header, because combos are not yet created for that one shot time field mapping.
  4. DOSPLUS

    Solved Creating combo boxes on the fly

    Hi, Been trying to find some code that allows for the creation of a combo box for each value that an SQL tables fields. Lets say 10 fields name in the table would yield 10 combo boxes setup one above each other. It is for mapping fields for import. I have the code to extract the fields names...
  5. DOSPLUS

    Solved Passing Form Control to a function.

    Hi All, Thx for the debug, sometimes when you are too inot the code you do not see your mistakes. As expected cheekybuddha 's solution works correctly. Thank you all for the advice.
  6. DOSPLUS

    Solved Passing Form Control to a function.

    Alright you guys! First of all, I'd like to thank you for taking the time to help. :) cheekybuddha 's solution seems to work correctly. Somehow the value (within the function scope) was not seen as an object and therefor could not find what to filter. Anyways, I did not have the time yet to...
  7. DOSPLUS

    Solved Passing Form Control to a function.

    HI Guys, I have been on this for a week now and cannot even see what I did wrong cause i am so close to it. In order to simplify things I did not include all the code as it is too big. Here we go... I got a function that is called from a form, lets say FORM1. As follow...
Back
Top Bottom