Recent content by a.jasper@gmx.ch

  1. A

    use Recordset inside SQL-statement

    Thanks a lot for technical backround, The_Doc_Man! It was very helpful for resolve my problem. After careful consideration the best and easiest method will be to copy datas from recordsets to temporary tables. But I will describe the problem in simplified way. May be do you have another...
  2. A

    use Recordset inside SQL-statement

    Thanks for fast response! useRS is a complex function which compares any col of recordset_a to any col of recordset_b. the return value is a recordset with col_rs_a and a col to have highest similarity in col_rs_b. i use this function very often for comparing filtered tables of different...
  3. A

    use Recordset inside SQL-statement

    dear guys! is it possible to use recordsets inside an sql-statement how described in folllow example. the error message: access can´t find the table or querydef. public function useRS (RS_ext_1 as DAO.Recordset, RS_ext_2 as DAO.Recordset) as DAO.Recordset dim sql_RS_int as string dim...
Top Bottom