Queries and Tables Flashing on screen when running a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LynneL - 29 Jul 2007 15:52 GMT

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.

Signature

Lynne

Reply to this Message

tina - 29 Jul 2007 16:08 GMT

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

> 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
[quoted text clipped - 4 lines]
> There are quite a few of them. Any suggestions on how to hide these queries
> as they run.

Reply to this Message

LynneL - 29 Jul 2007 16:40 GMT

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.

Signature

Lynne

> 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
[quoted text clipped - 16 lines]
> queries
> > as they run.

Reply to this Message

LynneL - 30 Jul 2007 19:50 GMT

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.

Signature

Lynne

> Tina,
>
[quoted text clipped - 22 lines]
> > queries
> > > as they run.

Reply to this Message

tina - 31 Jul 2007 03:56 GMT

you're welcome :)

> Tina,
>
[quoted text clipped - 28 lines]
> > > queries
> > > > as they run.

Reply to this Message