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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|