Showing related tags and posts accross the entire site.
Sorry, but there are no more tags available to filter with.
-
Here's some code I have to generate a SQL statement Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String
Dim sReturn As String
With clsRepLine
Select Case eType
...
-
Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...]