Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

running multiple queries

Status
Not open for further replies.
wshm

wshm

Programmer
Dec 7, 2006
62
US
is it possible to run multiple queries at once?

ie. DoCmd.OpenForm "frm_frmDeptBudget", , "qry_DeptactTxDetail_sum" And "qry_DeptBudTxDetail" And "qtest
 
Sort by date Sort by votes
Can you put them in line?

DoCmd.OpenForm "frm_frmDeptBudget"
DoCmd.OpenForm "qry_DeptactTxDetail_sum"
DoCmd.OpenForm "qry_DeptBudTxDetail"
DoCmd.OpenForm "qtest"
 
Upvote 0 Downvote
hm.. i just tried
DoCmd.OpenForm "frm_frmDeptBudget", , "qry_DeptactTxDetail_sum" & "qry_DeptBudTxDetail" & "qtest"

and i think it's working..
i'll let you know
 
Upvote 0 Downvote
Do you know the DoCmd.OpenQuery method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
227
Moss100
Moss100
rccline
  • Locked
  • Question
Running R script from Access module
Replies
8
Views
168
strongm
strongm
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
216
Andrzejek
Andrzejek
RolandR
  • Locked
  • Question
Winword AND Excel process still running after Quit and set to Nothing
Replies
6
Views
179
RolandR
RolandR
Sajjad668
  • Locked
  • Question
insert multiple image on single row in ms access database using vba
Replies
1
Views
103
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top