query on recordset in visual basic

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Someone is asking me to do a "query on a recordset" in VBScript,
claiming that in Visual Basic this

set conn=ADODB.connection
set rs1=ADODB.recordset
set rs2=ADODB.recordset
conn=<<set to someDB>>
rs1.open "select ename,age from emp"

rs2.open "select ename from rs1 where age >10"

msgbox rs2.recordcount

works. I doubt that - how could someDB know/access rs1 -
but not being familiar with Visual Basic, I thought it
wise to ask the experts.

If it is possible in Visual Basic, I would be very grateful
for a pointer to pertaining docs/samples.

Anybody who can do this in any other language could make my
day by telling me about ist.

Thanks.
.

Relevant Pages

  • Re: Data Access Page - SQL SELECT / INSERT
    ... VBScript to get you started: ... SAMPLE VISUAL BASIC SCRIPT CODE TO OPEN A RECORDSET TO AN ACTION QUERY, ... Dim vbs_adParamInput ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... Tools - references - tick Microsoft Outlook object library. ... in the criteria cell in the graphical query builder. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
    (microsoft.public.access.formscoding)