Hide Query Output

I am using the following code to run a query:
DoCmd.OpenQuery "qryLocation", acNormal, acEdit

The query works fine, but the results of the query display on the screen.
This was helpful when I was designing/debugging the application, but it is
distracting in the finished application.
Is there some way I can prevent the results from being displayed?

thanks


.

Relevant Pages

  • Re: Make Table Query question
    ... be entered and then store those results in either a fixed table or display ... on-the-fly results query display. ... A Select Query lets you do everything needed for a report ...
    (microsoft.public.access.queries)
  • Re: query criteria
    ... Terry Kreft ... I`ve made a query ... > into the criteria for the field in the query editor, ... I still want to have the query display the records and all ...
    (comp.databases.ms-access)
  • Re: Hide Query Output
    ... DoCmd.OpenQuery "qryLocation", acNormal, acEdit ... The query works fine, but the results of the query display on the screen. ... This was helpful when I was designing/debugging the application, ...
    (comp.databases.ms-access)
  • Re: Hide Query Output
    ... DoCmd.TransferSpreadsheet acExport, 8, "qryLocation", stDestination, False ... What I am doing is creating an Excel spread sheet based on the query. ... DoCmd.OpenQuery "qryLocation", acNormal, acEdit ... but the results of the query display on the ...
    (comp.databases.ms-access)
  • Show "Results in Text"
    ... Is there a way to make one particular query display its results as "Results ... in Text" when it is run in query analyzer without having to select it each ... time prior to running the query? ...
    (microsoft.public.sqlserver.server)