Making Bulk Changes : Query « Access « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Access » Query 




Making Bulk Changes
 
Sub RunUpdateQuery()
    Dim cnn As ADODB.Connection
    Set cnn = New ADODB.Connection

    Set cnn = CurrentProject.Connection
    cnn.Execute "qryIncreaseTotalEstimate"
    cnn.Close

End Sub

 














Related examples in the same category
1.Creating a Pass-Through Query with ADOX
2.Executing a Pass-Through Query Saved in Access
3.Using a Stored Procedure to Make Bulk Changes to Data in a SQL Server Database
4.Creating a Query Using Code
5.Create Query by using the Database.CreateQueryDef
6.User Defined Property
7.Get the created query name
8.Delete a query
9.Pass parameter to a query
10.Using CreateParameter to delete a company record
11.Execuate query
12.Update a table with QueryDef
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.