User Profile

Collapse

Profile Sidebar

Collapse
Bobbit
Bobbit
Last Activity: Aug 5 '11, 09:26 AM
Joined: May 30 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Bobbit
    replied to Stop Interim Tables from Opening when running multiple queries in MS Access
    in Access
    Thank you. I stand and corrected. So I didnt need to include the select queries to open. I didn't know that.
    As for A.Denzii code or reply, I didn't delete it. I couldn't open the link that was provided, but the code was included below: Here is the message.
    Again, I want to thank you for all your Help....


    This thread is located at:
    http://bytes.com/topic/access/answer...mand-all-selec...
    See more | Go to post
    Last edited by NeoPa; Jun 3 '11, 06:24 PM. Reason: Code MUST be posted using the CODE tags

      Leave a comment:

    • Bobbit
      replied to Stop Interim Tables from Opening when running multiple queries in MS Access
      in Access
      Hey "A.Dezii" .....Thank you so much

      The code works!! All of the Select Queries opened and closed. I see only 2 exceptions (1)Crosstab Query and (1) Union Query. Is there a way to include these 2 as well? Please advice and thank you so much for your help.

      Thank you All for all the quick replies.
      You guys are AWESOME!
      See more | Go to post

        Leave a comment:

      • Bobbit
        replied to Stop Interim Tables from Opening when running multiple queries in MS Access
        in Access
        Hi All,

        Thank you so much for all your quick reply on this. I actually do want those Select Queries to open since they are required to prep the Make Tables Queries. Is there some Command Code to close them all before opening the Form(Cap Error Result)?? I am trying to get away from manually Closing all the Select Queries that opened during the whole process.... Again Thank you so much...


        Bo.Bitt
        See more | Go to post

          Leave a comment:

        • Bobbit
          replied to Stop Interim Tables from Opening when running multiple queries in MS Access
          in Access
          Thanks NeoPa!! I will re-do the thread and include the code. Thank you for your quick reply....really appreciate your help....

          Code:
          Option Compare Database
Private Sub Run_All_Cap_Error_Queries_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "(1) Mod Data"
DoCmd.OpenQuery "(2) MonthDLQComp"
DoCmd.OpenQuery "(3) MonthlyTable"
DoCmd.OpenQuery "(4) BaseComp"
DoCmd.OpenQuery
          ...
          See more | Go to post
          Last edited by NeoPa; Jun 2 '11, 12:12 AM. Reason: Code MUST be posted using the CODE tags

            Leave a comment:

          • Bobbit
            started a topic Stop Interim Tables from Opening when running multiple queries in MS Access
            in Access

            Stop Interim Tables from Opening when running multiple queries in MS Access

            Hi All,

            I've created a command button to run multiple queries in Access. Everything run great except that all interim queries(Select Queries) open up and fills up my screen. I just close them all manually when it is done. Is there a way to omit these interim tables from Opening? Is there a code that I can add on so it will run all interim tables but omit them from opening? Please Help.....and thank you so much.

            Bobi...
            See more | Go to post
            No activity results to display
            Show More
            Working...