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...
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, @...
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...