How do I Hide the results of my Access Query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JrMonteCarlo24 - 22 Nov 2005 17:58 GMT

I have several queries in Access that I have to run to populate a some tables
and I don't want the users to see the result of each query that is run. I
would like the user to click a button to run the queries and just get the
final results not the results to the previous 4 queries.

Reply to this Message

Duane Hookom - 22 Nov 2005 19:13 GMT

What "results" are they seeing? Are they seeing the warning dialogs? If so,
use
DoCmd.SetWarnings False
and
DoCmd.SetWarnings True

Signature

Duane Hookom
MS Access MVP

>I have several queries in Access that I have to run to populate a some
>tables
> and I don't want the users to see the result of each query that is run. I
> would like the user to click a button to run the queries and just get the
> final results not the results to the previous 4 queries.

Reply to this Message

JrMonteCarlo24 - 22 Nov 2005 19:30 GMT

They are seeing the results in the Datasheet view.

> What "results" are they seeing? Are they seeing the warning dialogs? If so,
> use
[quoted text clipped - 7 lines]
> > would like the user to click a button to run the queries and just get the
> > final results not the results to the previous 4 queries.

Reply to this Message

Rick Brandt - 22 Nov 2005 20:30 GMT

> They are seeing the results in the Datasheet view.

Actions queries are executed. There is no reason to "open" them in datasheet
view to get them to work.

What does your button code look like?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

JrMonteCarlo24 - 22 Nov 2005 21:22 GMT

DoCmd.SetWarnings False

stDocName = "JantoDec"
DoCmd.OpenQuery stDocName, acViewNormal, acReadOnly

stDocName2 = "CurrentPeriod"
DoCmd.OpenQuery stDocName2, acViewNormal, acReadOnly

stDocName3 = "OneThruPriorPeriod"
DoCmd.OpenQuery stDocName3, acViewNormal, acReadOnly

stDocName4 = "ContractChanges"
DoCmd.OpenQuery stDocName4, acViewNormal, acReadOnly

> > They are seeing the results in the Datasheet view.
>
> Actions queries are executed. There is no reason to "open" them in datasheet
> view to get them to work.
>
> What does your button code look like?

Reply to this Message

Duane Hookom - 22 Nov 2005 22:57 GMT

Are these queries Action or Select queries? Maybe you could provide the SQL
view of one or more of these.

Signature

Duane Hookom
MS Access MVP
--

> DoCmd.SetWarnings False
>
[quoted text clipped - 17 lines]
>>
>> What does your button code look like?

Reply to this Message

Gina Whipp - 23 Nov 2005 15:38 GMT

Try:

DoCmd.SetWarnings False
DoCmd.OpenQuery "JantoDec"
DoCmd.OpenQuery "CurrentPeriod"
DoCmd.OpenQuery "OneThruPriorPeriod"
DoCmd.OpenQuery "ContractChanges"
DoCmd.SetWarnings True

Queries SHOULD run in the background without opening...

> DoCmd.SetWarnings False
>
[quoted text clipped - 17 lines]
>>
>> What does your button code look like?

Reply to this Message