How to assign to a recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using ADO to open a recordset. After opened, I need to inner join this recordset with another ADO recordset. How can I assign this recordset to a variable? Thanks.
 
WC Lo said:
I am using ADO to open a recordset. After opened, I need to inner join
Click to expand...
this recordset with another ADO recordset. How can I assign this recordset
to a variable? Thanks.

Post sample code!
 
Hi Ron, Please see my another thread "VBE Hangs". I've posted the code there. I am thinking I need a recordset variable in order to hold another recordset. This causes my VBE hangs.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A theoretical question: how best to manage perpetual recordset needs? 25
Stumped by a Type mismatch error 2
Using bookmarks causes recordset to lose knowledge of its Max records? 3
Query a recordset? 4
Recordset changes underlying table automatically 5
How to refer to a VBA module variable within a report select state 3
How to get form record to equal recordset record? 16
Recordsets in Subroutines 4

Back
Top