Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Open the invisble query

    Hi,

    I have a question.

    In VBA, can we select the object, query, and then open it as invisble status and then close it?

    I just know that

    Docmd.openquery "qry1"
    docmd.Close acQuery,"qry1"

    But, I want to make it in the invisible status, nobody read it on the screen.

    Can we do that?

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Sure......if you open it as a recordset. Then you can loop through your recordset to take care of any business you may have to do with it.

Posting Permissions

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