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