Re: Hide Query Output

Here is the actual code :

DoCmd.OpenQuery "qryLocation", , acNormal, acEdit
DoCmd.TransferSpread*** acExport, 8, "qryLocation", stDestination, False

qryLocation selects a set of records based on a City and Street.

What I am doing is creating an Excel spread *** based on the query.

Thanks


"Keith Wilby" <here@xxxxxxxxx> wrote in message
news:447d907e$1_1@xxxxxxxxxxxxxxxxxxxxxxxxx
"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




.

Quantcast