Queries and Tables Flashing on screen when running a report

L

LynneL

I am running a report from a menu screen. When I click on the button to
display the report, I run a bunch of macros to run the queries to create the
report. I just want to click the button and when it is done show the report.
Instead, its flashes each of the queries, make tables and results of each
query on the screen as it is processing each one. When they are done the
report then displays. I don't want the user to see these query results.
There are quite a few of them. Any suggestions on how to hide these queries
as they run.
 
T

tina

normally Action queries (Append, Update, Delete, Make Table) don't "open" to
a query datasheet, they just execute the action. sounds like at least some
of your macros are running "Select" queries, which don't *do* anything, they
just return datasets. you don't need to "run" the Select queries, just run
any Action queries that are required, then open the report.

hth
 
L

LynneL

Tina,

You are correct..... I do have a lot of Select queries along with my action
queries which my macros are running. I will try your suggestion and see if
that helps. Thanks.
 
L

LynneL

Tina,

I tried your suggestion and it worked perfectly. Thanks so much. I pulled
all of the Select queries out of my macros and then ran it again and the
report came up without the queries flashing on the screen.
 
T

tina

you're welcome :)


LynneL said:
Tina,

I tried your suggestion and it worked perfectly. Thanks so much. I pulled
all of the Select queries out of my macros and then ran it again and the
report came up without the queries flashing on the screen.
Click to expand...
 
Top