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