Macros and queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Robert
    #1

    Macros and queries

    I've got a Macro that runs a few Queries and then ends with a Report. It
    opens all the Queries and leaves them open and I'd really prefer that it not
    do that. Is there a way to just run the Queries and/or close them
    immediately?

    Thanks,
    Robert


    Tags: None
    • Trevor Best
      #2
      Re: Macros and queries

      Robert wrote:[color=blue]
      > I've got a Macro that runs a few Queries and then ends with a Report. It
      > opens all the Queries and leaves them open and I'd really prefer that it not
      > do that. Is there a way to just run the Queries and/or close them
      > immediately?[/color]

      I don't use macros but I think there's a close command you can use? I
      don't see the point of opening a select query if you're not looking at
      it's contents anyway, action queries I can understand running before a
      report to do something that the report needs but they don't open on
      screen, just execute so automatically close anyway.

      --
      [OO=00=OO]

        Comment

        • Robert
          #3
          Re: Macros and queries

          The Select Query is choosing the Records for my Report.

          Robert

          "Trevor Best" <nospam@besty.o rg.uk> wrote in message
          news:42ecdf63$0 $4965$db0fefd9@ news.zen.co.uk. ..[color=blue]
          > Robert wrote:[color=green]
          >> I've got a Macro that runs a few Queries and then ends with a Report. It
          >> opens all the Queries and leaves them open and I'd really prefer that it
          >> not do that. Is there a way to just run the Queries and/or close them
          >> immediately?[/color]
          >
          > I don't use macros but I think there's a close command you can use? I
          > don't see the point of opening a select query if you're not looking at
          > it's contents anyway, action queries I can understand running before a
          > report to do something that the report needs but they don't open on
          > screen, just execute so automatically close anyway.
          >
          > --
          > [OO=00=OO][/color]


            Comment

            • Robert
              #4
              Re: Macros and queries

              Never mind. I figured out that I can use a Filter instead of the Query to
              build my Report.

              Thanks. Lot's to learn but I'm getting there. This is kinda' cool.


              "Robert" <robb1@email.co m> wrote in message
              news:3_ednfiPKN OpSXHfRVn-pg@comcast.com. ..[color=blue]
              > I've got a Macro that runs a few Queries and then ends with a Report. It
              > opens all the Queries and leaves them open and I'd really prefer that it
              > not do that. Is there a way to just run the Queries and/or close them
              > immediately?
              >
              > Thanks,
              > Robert
              >[/color]


                Comment

                Previous template Next
                Working...