Results 1 to 2 of 2

Thread: SOLVED access: put result of existing query in recordset

  1. Sep 6th, 2002, 03:59 AM #1
    c@lle
    c@lle is offline

    Thread Starter
    Addicted Member c@lle's Avatar
    Join Date
    Oct 1999
    Location
    Belgium
    Posts
    179

    SOLVED access: put result of existing query in recordset

    what is the easiest way to put the result of an existing query (qryOutbox) in a ADODB recordset?

    thus, i have created a query in access, saved it with the name 'qryOutbox' and now i want to use this in VBA.

    how can i put the result in the recordset, so that i can change values from certain fields?

    thanks.
    Last edited by c@lle; Sep 6th, 2002 at 06:10 AM.
    Reply With Quote Reply With Quote
  2. Sep 6th, 2002, 05:12 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Code:
    Select qryOutbox.* from qryOutbox
    Put that as the source when opening your recordset in ado (remember adCmdText as the last option when opening.


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width