vba excel combobox loading values from query ms access

  • Re: vba excel combobox loading values from query ms access


    Sorry, Fdata was just a test... I am going to try with your code...Thanks again!

  • Re: vba excel combobox loading values from query ms access


    It doesn't work. I really don't get it. UBound(FirstNames) or UBound(LastNames) is 0. From the beginning the code did not want to read the first recordset. :(


    At the end, all for nothing.

  • Re: vba excel combobox loading values from query ms access


    This is the final version... I tested it and it works.... it was really simple... Enjoy!
    :0ops:


    However, this is ADO and DAO together!!!
    http://www.fontstuff.com/vba/vbatut10.htm


    Code
    With ComboBox1
              Do
                  .AddItem rs![First_Name]
                  rs.MoveNext
              Loop Until rs.EOF        
          End With






    :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!