Re: Hide Query Output

"RICHARD BROMBERG" <noreply@xxxxxxx> wrote in message
news:j4gfg.195204$eR6.112634@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


Why are you opening a query if you don't want to view the results? What is
it that you're wanting to achieve?

Keith.
www.keithwilby.com


.

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.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)
  • Hide Query Output
    ... DoCmd.OpenQuery "qryLocation", acNormal, acEdit ... The query works fine, but the results of the query display on the screen. ...
    (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)