Code:
With ActiveWorkbook.Connections("mnlsapp02 SLP B10Data") _
.OLEDBConnection
.BackgroundQuery = True
.CommandText = Array( _
"SELECT
c112994
Last Activity: May 21 '14, 12:58 AM
Joined: Apr 29 '14
Location:
-
Subscript out of range error
Hello, I keep getting subscript out of range error when connection to the database and I can't figure out why, there is already an existing connection with the table. Any help would be highly appreciated, thank you!
... -
Okay, I already got it. Thanks! -
Oh okay, so how should I fix this? Or how must I approach it to fix it?Leave a comment:
-
Hi! Thanks for the help, I edited my code into this but it still gives me only the first value from the database?
...Code:Sub Runner() Dim folderName As String Dim salesPeriod As String Dim Region As String Dim cn As ADODB.Connection Dim cms As ADODB.Command Dim rs As ADODB.Recordset Dim SQL As String 'Make Output Folder folderNameLeave a comment:
-
Why is my RecordSet containing only 1 value and RecordCount = -1?
Why does my RecordSet only get the first value in the database? There are supposed to be 41 districts but only the first one is returned
Here is my code, help me please. Thank you
...Code:Sub Runner() Dim folderName As String Dim salesPeriod As String Dim Region As String Dim cn As ADODB.Connection Dim cms As ADODB.Command Dim rs As ADODB.RecordsetLast edited by Rabbit; Apr 29 '14, 03:30 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: