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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jsneed
-
Returning all WMI values
Dim strComputerName ' The Computer Name to be queried via WMI Dim strWinMgt ' The WMI management String Dim objCon ' A Connection Object for database connectivity Dim objRS ' A Recordset Object for database connectivity Dim sProviderName ' The OLE Provider Type Dim iCursorType ' The Cursor...- jsneed
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Returning all WMI values
nevermind I figured it out- jsneed
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Returning all WMI values
This code is working but it only returns the first value that is queried into the database. How do I make it write all info it finds into the database? Sub subWriteSoftwareInfo set colItems = GetObject(strWinMgt).ExecQuery("select * from Win32_Product") objRS.CursorType =...- jsneed
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
