Disapearing Query Results!

[AMohamadi]

Hello Dear

I have some Combo Box's on a form that extract data from queries
When queries run,the results show to the user that is not necessary!
Is it possible to hide query results from user?

Thanks
Best Regards

 

[John Spencer]

The question is unclear.

Do you want to show the results of a query in the form?

Are you seeing query results in data sheet view and don't want to?
If this is the case, then you must be executing the query in some manner and
opening the query. We cannot see your application and cannot see what you are
doing.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[AMohamadi]

Hello and Thanks
You are right! I'm seeing Query result in Data Sheet view but i don't want it!
About my program:In short,I want to simulating MS-Excel Filter in MS-Access
and i need to run queries in the background of system so user doesn't need to
see what is happening.It just needs final result!

best regards

 

[John W. Vinson]

Hello and Thanks
You are right! I'm seeing Query result in Data Sheet view but i don't want it!
About my program:In short,I want to simulating MS-Excel Filter in MS-Access
and i need to run queries in the background of system so user doesn't need to
see what is happening.It just needs final result!

If you just want the combo box to contain the results of the query, don't
*run* the query at all; instead, set the combo box's Rowsource property to the
SQL string.

 

[AMohamadi]

Unfortunately i need queries result for tow purposes,One for combo boxes data
source and another for next query as input!

Please pay attention: I have 5 queries and 5 combo boxes,The first combo box
reads RowSource data from a table and after it changes query no.1 runs and
selects specific records from that table that are match in the special field
with combo box no.1,in the next step combo box no.2 gets it's required data
from query no.1 and after it changes,query no.2 runs and selects some records
from query no.1 and so on...... until when query no.5 runs,Job is done and
now at this time user must see final selected records and do some special
works!

So i just need to see the results of query no.5!

Please help me
thanks Sooooooooo!

 

[John W. Vinson]

Unfortunately i need queries result for tow purposes,One for combo boxes data
source and another for next query as input!

There is still NO REASON to "run" the query and open a query datasheet.

The SQL of the second query can reference the name of the first query.

Please pay attention: I have 5 queries and 5 combo boxes,The first combo box
reads RowSource data from a table and after it changes query no.1 runs and
selects specific records from that table that are match in the special field
with combo box no.1,in the next step combo box no.2 gets it's required data
from query no.1 and after it changes,query no.2 runs and selects some records
from query no.1 and so on...... until when query no.5 runs,Job is done and
now at this time user must see final selected records and do some special
works!

That seems to be an extremely convoluted way of doing things but... ok; you
can set the second combo's rowsource in the AfterUpdate event of the first,
and so on.

So i just need to see the results of query no.5!

Then that's the ONLY query that you need to actually open.

 

[AMohamadi]

At last,No body could say me how to hide query's result Datasheet!

 

[John W. Vinson]

At last,No body could say me how to hide query's result Datasheet!

I did.

Just DON'T RUN THE QUERY.

It is not necessary to run the query, and open the query datasheet, in order
to do what you are asking.

If you do run the query then you cannot hide the query datasheet.

Take your pick - create a query and open it, and look at the query datasheet;
or create a query, DON'T open it, and use it as the Rowsource of a combo box
(or any other of the many uses to which queries can be put).

You are causing your own problem.

 

[AMohamadi]

Bravo
Thanks So
Until know i thought for using query results,It must first run and then...
But know i saw it works without opening!

 

[John W. Vinson]

Bravo
Thanks So
Until know i thought for using query results,It must first run and then...
But know i saw it works without opening!

<g> It is really counterintuitive! Your confusion was reasonable, and many
others (including myself, some time back) have been caught by it.