Invalid SQL on INSERT Doctor 11/21/2008 5:45:01 PM I continue to get an "invalid SQL error" with the following SQL. When I copy the sql from the immediate window into a query, it runs fine. Here is the code generating the sql statment. 'Create Link in tblLLCRegLink If Not IsNothing(strGroupID) Then Me.LLCRegGroupID.Requery Me.LLCRegGroupID.Value = strGroupID strSQLa = "INSERT tblLLCRegLink ( LLCRegGroupID, LLCRegID ) " & _ "SELECT " & strGroupID & " AS Expr1, " & strGroup & " AS Expr2 ;" Debug.Print strSQLa DoCmd.SetWarnings False DoCmd.RunSQL strSQL2 DoCmd.SetWarnings True Me.sfrmLLCRegLink.Requery Here is a sample SQL statement generated in the Immediate window. INSERT INTO tblLLCRegLink ( LLCRegGroupID, LLCRegID ) SELECT 9 AS Expr1, 281 AS Expr2 ; I'm not sure what to do. Any help would be tremendously appreciated. Thanks. And may I say, I love this site! Constantly find help here (even if I only post once a month or so) Kudos to those of you who are willing to help those like me.

RE: Invalid SQL on INSERT Dorian 11/21/2008 6:11:01 PM How are your columns defined (LLCRegGroupID, LLCRegID )? Where is your FROM clause? Why do you have 'As Expr1' and 'As Expr2'? -Dorian "Doctor" wrote: [Quoted Text] > I continue to get an "invalid SQL error" with the following SQL. When I copy > the sql from the immediate window into a query, it runs fine. > > Here is the code generating the sql statment. > > 'Create Link in tblLLCRegLink > If Not IsNothing(strGroupID) Then > Me.LLCRegGroupID.Requery > Me.LLCRegGroupID.Value = strGroupID > strSQLa = "INSERT tblLLCRegLink ( LLCRegGroupID, LLCRegID ) " & _ > "SELECT " & strGroupID & " AS Expr1, " & strGroup & " AS Expr2 ;" > Debug.Print strSQLa > DoCmd.SetWarnings False > DoCmd.RunSQL strSQL2 > DoCmd.SetWarnings True > Me.sfrmLLCRegLink.Requery > > > Here is a sample SQL statement generated in the Immediate window. > > INSERT INTO tblLLCRegLink ( LLCRegGroupID, LLCRegID ) SELECT 9 AS Expr1, 281 > AS Expr2 ; > > I'm not sure what to do. Any help would be tremendously appreciated. > > Thanks. > > > > And may I say, I love this site! Constantly find help here (even if I only > post once a month or so) Kudos to those of you who are willing to help those > like me.

Re: Invalid SQL on INSERT "Cyberwolf0000 via AccessMonster.com" <u42640[ at ]uwe> 11/21/2008 6:26:17 PM Doctor wrote: [Quoted Text] >I continue to get an "invalid SQL error" with the following SQL. When I copy >the sql from the immediate window into a query, it runs fine. > >Here is the code generating the sql statment. > > 'Create Link in tblLLCRegLink > If Not IsNothing(strGroupID) Then > Me.LLCRegGroupID.Requery > Me.LLCRegGroupID.Value = strGroupID > strSQLa = "INSERT tblLLCRegLink ( LLCRegGroupID, LLCRegID ) " & _ > "SELECT " & strGroupID & " AS Expr1, " & strGroup & " AS Expr2 ;" > Debug.Print strSQLa > DoCmd.SetWarnings False > DoCmd.RunSQL strSQL2 > DoCmd.SetWarnings True > Me.sfrmLLCRegLink.Requery > >Here is a sample SQL statement generated in the Immediate window. > >INSERT INTO tblLLCRegLink ( LLCRegGroupID, LLCRegID ) SELECT 9 AS Expr1, 281 >AS Expr2 ; > >I'm not sure what to do. Any help would be tremendously appreciated. > >Thanks. > >And may I say, I love this site! Constantly find help here (even if I only >post once a month or so) Kudos to those of you who are willing to help those >like me. You have the DoCmd.RunSQL set to strSQL2 and you are building a strSQLa -- James B Gaylord For the Wolf comes the strength of the Pack, For the Pack comes the strength of the Wolf, -R. Kipling Office 2003 on Win XP SP2 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: Invalid SQL on INSERT "Dirk Goldgar" <dg[ at ]NOdataSPAMgnostics.com.invalid> 11/21/2008 6:26:37 PM "Doctor" <Doctor[ at ]discussions.microsoft.com> wrote in message news:A53F697C-99DA-4E1D-A9EB-ED1EEA360ED3[ at ]microsoft.com... [Quoted Text] >I continue to get an "invalid SQL error" with the following SQL. When I >copy > the sql from the immediate window into a query, it runs fine. > > Here is the code generating the sql statment. > > 'Create Link in tblLLCRegLink > If Not IsNothing(strGroupID) Then > Me.LLCRegGroupID.Requery > Me.LLCRegGroupID.Value = strGroupID > strSQLa = "INSERT tblLLCRegLink ( LLCRegGroupID, LLCRegID ) " & > _ > "SELECT " & strGroupID & " AS Expr1, " & strGroup & " AS Expr2 > ;" > Debug.Print strSQLa > DoCmd.SetWarnings False > DoCmd.RunSQL strSQL2 > DoCmd.SetWarnings True > Me.sfrmLLCRegLink.Requery > > > Here is a sample SQL statement generated in the Immediate window. > > INSERT INTO tblLLCRegLink ( LLCRegGroupID, LLCRegID ) SELECT 9 AS Expr1, > 281 > AS Expr2 ; There's something odd here, because the code you posted doesn't include the "INTO" keyword in building strSQLa, but you have it in what you say was printed in the Immediate window. Also, the code you posted *builds* strSQLa, but *executes* strSQL2. Did you type all the code into your message freehand, rather than copying and pasting? Or is are these discrepancies the cause of your error? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)

Re: Invalid SQL on INSERT Doctor 11/25/2008 1:07:01 PM Thanks so much. I knew it would be something simple and foolish. "Cyberwolf0000 via AccessMonster.com" wrote: [Quoted Text] > Doctor wrote: > >I continue to get an "invalid SQL error" with the following SQL. When I copy > >the sql from the immediate window into a query, it runs fine. > > > >Here is the code generating the sql statment. > > > > 'Create Link in tblLLCRegLink > > If Not IsNothing(strGroupID) Then > > Me.LLCRegGroupID.Requery > > Me.LLCRegGroupID.Value = strGroupID > > strSQLa = "INSERT tblLLCRegLink ( LLCRegGroupID, LLCRegID ) " & _ > > "SELECT " & strGroupID & " AS Expr1, " & strGroup & " AS Expr2 ;" > > Debug.Print strSQLa > > DoCmd.SetWarnings False > > DoCmd.RunSQL strSQL2 > > DoCmd.SetWarnings True > > Me.sfrmLLCRegLink.Requery > > > >Here is a sample SQL statement generated in the Immediate window. > > > >INSERT INTO tblLLCRegLink ( LLCRegGroupID, LLCRegID ) SELECT 9 AS Expr1, 281 > >AS Expr2 ; > > > >I'm not sure what to do. Any help would be tremendously appreciated. > > > >Thanks. > > > >And may I say, I love this site! Constantly find help here (even if I only > >post once a month or so) Kudos to those of you who are willing to help those > >like me. > > > You have the DoCmd.RunSQL set to strSQL2 and you are building a strSQLa > > -- > James B Gaylord > For the Wolf comes the strength of the Pack, > For the Pack comes the strength of the Wolf, > -R. Kipling > Office 2003 on Win XP SP2 > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1 > >