A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Disapearing Query Results!



 
 
Thread Tools Display Modes
  #1  
Old February 27th, 2010, 03:06 PM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!

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
  #2  
Old February 28th, 2010, 02:53 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 7,815
Default Disapearing Query Results!

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 wrote:
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

  #3  
Old March 1st, 2010, 07:13 AM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!

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 Spencer" wrote:

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 wrote:
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

.

  #4  
Old March 1st, 2010, 08:12 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Disapearing Query Results!

On Sun, 28 Feb 2010 22:13:01 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
  #5  
Old March 2nd, 2010, 06:22 AM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!

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" wrote:

On Sun, 28 Feb 2010 22:13:01 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
.

  #6  
Old March 2nd, 2010, 07:15 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Disapearing Query Results!

On Mon, 1 Mar 2010 21:22:01 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
  #7  
Old March 2nd, 2010, 09:38 AM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!

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

"John W. Vinson" wrote:

On Mon, 1 Mar 2010 21:22:01 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
.

  #8  
Old March 2nd, 2010, 06:32 PM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Disapearing Query Results!

On Tue, 2 Mar 2010 00:38:03 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
  #9  
Old March 3rd, 2010, 06:32 AM posted to microsoft.public.access.queries
AMohamadi
external usenet poster
 
Posts: 6
Default Disapearing Query Results!


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" wrote:

On Tue, 2 Mar 2010 00:38:03 -0800, AMohamadi
wrote:

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.

--

John W. Vinson [MVP]
.

  #10  
Old March 3rd, 2010, 07:54 AM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Disapearing Query Results!

On Tue, 2 Mar 2010 21:32:01 -0800, AMohamadi
wrote:

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.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.