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  

Running multiple queries in ACCESS 2000



 
 
Thread Tools Display Modes
  #1  
Old October 19th, 2004, 05:26 PM
TG
external usenet poster
 
Posts: n/a
Default Running multiple queries in ACCESS 2000

I am trying to execute multiple queries using one command button will
this work or should I be doing something else? Here is my code...

Private Sub cmdClearData_Click()
On Error GoTo Err_cmdClearData_Click

Dim stDocName As String

stDocName = "qry_Delete_T1_Clients,
qry_Delete_T9_Clinic_Attendance, qry_Delete_T9_Clients_Massage,
qry_Delete_T1_Students, qry_Delete_T1_STD_Program,
qry_Delete_T9_Clinic_Roster, qry_Delete_T9_Clinic_Sessions,
qry_Delete_T9_Session_Times"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_cmdClearData_Click:
Exit Sub

Err_cmdClearData_Click:
MsgBox Err.Description
Resume Exit_cmdClearData_Click

End Sub
  #2  
Old October 19th, 2004, 05:45 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

Won't work. You would need to open each separately.

--
Duane Hookom
MS Access MVP
--

"TG" wrote in message
om...
I am trying to execute multiple queries using one command button will
this work or should I be doing something else? Here is my code...

Private Sub cmdClearData_Click()
On Error GoTo Err_cmdClearData_Click

Dim stDocName As String

stDocName = "qry_Delete_T1_Clients,
qry_Delete_T9_Clinic_Attendance, qry_Delete_T9_Clients_Massage,
qry_Delete_T1_Students, qry_Delete_T1_STD_Program,
qry_Delete_T9_Clinic_Roster, qry_Delete_T9_Clinic_Sessions,
qry_Delete_T9_Session_Times"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_cmdClearData_Click:
Exit Sub

Err_cmdClearData_Click:
MsgBox Err.Description
Resume Exit_cmdClearData_Click

End Sub



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access XP Compared to Access 2003 Mardene Leahu New Users 1 October 1st, 2004 05:11 AM
Running Access 2000 in Windows XP professional Charles Delap General Discussion 2 September 26th, 2004 11:38 AM
How do I set up a field in Access 2000 to accept multiple combo b. CMorgan Using Forms 3 September 8th, 2004 07:48 PM
Access 2000 SP-3 corrupts mdb for Access 2003 SP-1? Ola General Discussion 7 August 17th, 2004 09:51 AM
Access 2000 DB in Access 2002 Tony_VBACoder General Discussion 2 July 28th, 2004 01:23 AM


All times are GMT +1. The time now is 12:01 AM.


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