• Looping through queries (Access 97 SR 2)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Looping through queries (Access 97 SR 2)

    Author
    Topic
    WSBillSutterfield
    AskWoody Lounger
    February 14, 2002 at 7:55 pm #366892

    I have created a large group of queries that I would like ouput to Excel. I often need to add or delete. I’ve created a macro through the Macro tab to output them but I would like to use VBA instead. I would like to just loop through, running each query and sending the results to an Excel file with the file name that of the query. Any help would be greatly appreciated.

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSMarkLiquorman
      AskWoody Lounger
      February 14, 2002 at 8:25 pm #570440

      Lookup “TransferSpreadsheet” in Help, and I think you will find what you need for correctly writing the code to export a query to Excel.

      Reply | Quote
      • WSBillSutterfield
        AskWoody Lounger
        February 15, 2002 at 1:31 pm #570562

        Thanks for the reply. I had the code to export ,what I can’t figure out is how to loop through each query. Something like
        For each query in database
        docmd…

        Reply | Quote
        • WSrory
          AskWoody Lounger
          February 15, 2002 at 2:09 pm #570575

          Hi,
          You need to look at the querydefs collection. Something like:
          for each qdfTemp in currentdb.querydefs
          ….
          next qdfTemp
          Hope that helps.

          Reply | Quote
    • WSFrancois
      AskWoody Lounger
      February 14, 2002 at 9:21 pm #570471

      In the database window, Tab Macros, right-click on a macro. Click Save As/ Export. Check Save as Visual Basic Module and press OK. Check or uncheck Add error… and Include Macro Comments and click Convert. In the Module tab of the database windows you have now a module named Converted Macro – Name Of the Macro. This module will act the same as the macro. Start with this to learn VBA code

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Looping through queries (Access 97 SR 2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.