Recent content by Zadotchi

  1. Z

    Concatenate Column Values from Multiple Rows into a Single Column

    HI BioBee finaly I got the code to work after I reference to Microsoft Active Library 2.1 but the result is not right here is what my data looks like tblCourses SeqNo Stu_Id Year Semester Course_No Curse_Name Status Grade 1 1 2011 Spring S_11_01 IT_S_11_1 Pass 3.2 2 1...
  2. Z

    Concatenate Column Values from Multiple Rows into a Single Column

    In Fact I imported the original table tblData and all three quesries and Module1 to my database, and it gave the same error when I execute either imported quesr when I run it from your database on my desktop it works fine Yesterday I had copy of my work database, it gave the same error, @...
  3. Z

    Concatenate Column Values from Multiple Rows into a Single Column

    HI All I like the code, and I tried it on my database, 'I get a compile error with this line of code saying "User-defined type not defined" and the Public Function Conc(Fieldx, Identity, Value, Source) As Variant Dim cnn As ADODB.Connection is highlighted I already created the Module1...
Back
Top Bottom