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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Compile Error: Syntx Error
That's the question. I can't create a Parameter Query in Mic Query. I must create a Macro to edit accordingly. The problem arises in VBA. I can't detect any Syntax Error. However, because I don't usually work SQL in VBA I may be missing something, hence my decision to create a Thread here... -
Compile Error: Syntx Error
Greetings! Recently I started using VBA to programm Microsoft Query, with help of Macro Recorder (wich seems to make somewhat of a mess). Relative to the code below I get "Compile Error: Syntax Error" and can't understand why: .CommandText = Array( _ "SELECT Groups.`Group Name`, `Flown... -
Syntax error?
Greetings! Recently I started using VBA to programm Microsoft Query, with help of Macro Recorder (wich seems to make somewhat of a mess). Relative to the code below I get Syntax Error and can't understand why: .CommandText = Array( _ "SELECT Groups.`Group Name`, `Flown Revenue...
