Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Unanswered: Accessing Query Results...

    I am new to Access and am trying programatically to access the results of a query I defined in the query builder for Access. I have the query built and it works, but how can I grab the results into variable that I can use in the code.

    Thanks
    c

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    your query returns a set of records --- a "recordset"
    try searching this forum or your access help system (if it works!!!) for "recordset".

    for a simple example (including me bumbling about fixing blindingly stupid errors) see
    http://dbforums.com/t761254.html
    you would need to substitute the name of your canned query along the lines of:

    set reci = dabs.openrecordset("NameOfMyCannedQuery")

    izy
    Last edited by izyrider; 04-28-03 at 14:40.

Posting Permissions

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