Results 1 to 6 of 6

Thread: Setting recordset to query in Access VBA [Solved]

Threaded View

  1. Mar 3rd, 2005, 01:24 PM #1
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Setting recordset to query in Access VBA [Solved]

    hey I am trying to set a recordset to a query in my database so I can use the .findfirst function. I keep getting a error saying that the item is not found in the collection.

    Is this possible or do I have to use a table instead of a query for my recordset?

    the code I am using is:

    VB Code:
    1. Dim rcQuery1 as Recordset

    2.  
    3. Set rcQuery1 = Recordset("Query1")

    I am getting stuck on the set statement.

    Thanks for any help.
    Last edited by Besoup; Mar 3rd, 2005 at 02:21 PM.
    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