|
| 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
March 8th, 2006, 07:38 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
command button to run 2 querys
Hi there,
Is it possible to have a command button run more than 1 query? I have 2 querys "qry_CommentType" and "qry_CommentTypeTotal". The "qry_CommentType" needs to be run before the other one. Right now I have 2 command buttons on my form to run each query separately. Any great is greatly appreciated! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1 
|
|
#2
March 8th, 2006, 07:48 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
command button to run 2 querys
Yes, you can have one button do them all, and they'll run synchronously,
which means query 2 will wait for query 1 to finish. it's done all the time. Sam zaps wrote: Hi there, Is it possible to have a command button run more than 1 query? I have 2 querys "qry_CommentType" and "qry_CommentTypeTotal". The "qry_CommentType" needs to be run before the other one. Right now I have 2 command buttons on my form to run each query separately. Any great is greatly appreciated! -- Sam Message posted via http://www.accessmonster.com
|
|
#3
March 8th, 2006, 08:26 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
command button to run 2 querys
Do you know how I can do this? Also, could I have the button run the 2
querys in sequence, and then open up a report? OfficeDev18 wrote: Yes, you can have one button do them all, and they'll run synchronously, which means query 2 will wait for query 1 to finish. it's done all the time. Sam Hi there, Is it possible to have a command button run more than 1 query? I have 2 querys "qry_CommentType" and "qry_CommentTypeTotal". The "qry_CommentType" needs to be run before the other one. Right now I have 2 command buttons on my form to run each query separately. Any great is greatly appreciated! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1
|
|
#4
March 8th, 2006, 08:52 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
command button to run 2 querys
DoCmd.OpenQuery "the first query name in quotes",...etc.
DoCmd.OpenQuery "the second query name in quotes",...etc. DoCmd.OpenReport "your report name in quotes",...etc. You can see the methods in the help file for details. Sam zaps wrote: Do you know how I can do this? Also, could I have the button run the 2 querys in sequence, and then open up a report? Yes, you can have one button do them all, and they'll run synchronously, which means query 2 will wait for query 1 to finish. it's done all the time. [quoted text clipped - 6 lines] needs to be run before the other one. Right now I have 2 command buttons on my form to run each query separately. Any great is greatly appreciated! -- Sam Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating A Monthy Report Based On Several Querys | StuJol | Setting Up & Running Reports | 6 | September 5th, 2005 09:40 AM |
| I have three querys all form one table and want to make one chart | Tom | General Discussion | 0 | June 23rd, 2005 11:56 PM |
| AND querys | Chris H | Running & Setting Up Queries | 1 | May 26th, 2005 05:01 PM |
| Help, Need to Email Querys | Richard Albrecht | General Discussion | 1 | February 24th, 2005 07:12 PM |
| Samples of time querys | Kenny M. | Running & Setting Up Queries | 1 | December 14th, 2004 05:02 AM |
Linear Mode
