Results 1 to 13 of 13
  1. #1
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54

    Run Time Error 3144 for UPDATE

    First of all, I just want to say that this forum is awesome. You guys always give the the solution I am looking for.



    Basically I am receiving the above error (3144), here is all the code it is highlighting. Any help would be appreciated!!!


    Original:

    Code:
    DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _
    " SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID]," & _
    " Tbl_MasterReviewRecord.Goal1Chk = [Tbl_ReviewRecord]![Goal1Chk], Tbl_MasterReviewRecord.Goal2Chk = [Tbl_ReviewRecord]![Goal2Chk], Tbl_MasterReviewRecord.Goal3Chk = [Tbl_ReviewRecord]![Goal3Chk], Tbl_MasterReviewRecord.Goal4Chk = [Tbl_ReviewRecord]![Goal4Chk], Tbl_MasterReviewRecord.Goal5Chk = [Tbl_ReviewRecord]![Goal5Chk], Tbl_MasterReviewRecord.Goal6Chk = [Tbl_ReviewRecord]![Goal6Chk], Tbl_MasterReviewRecord.Goal7Chk = [Tbl_ReviewRecord]![Goal7Chk], Tbl_MasterReviewRecord.Goal8Chk = [Tbl_ReviewRecord]![Goal8Chk]," & _
    " Tbl_MasterReviewRecord.FocusChk = [Tbl_ReviewRecord]![FocusChk], Tbl_MasterReviewRecord.LeadChk = [Tbl_ReviewRecord]![LeadChk], Tbl_MasterReviewRecord.ResultsChk = [Tbl_ReviewRecord]![ResultsChk], Tbl_MasterReviewRecord.PeopleChk = [Tbl_ReviewRecord]![PeopleChk], Tbl_MasterReviewRecord.ChampChk = [Tbl_ReviewRecord]![ChampChk], Tbl_MasterReviewRecord.FosterChk = [Tbl_ReviewRecord]![FosterChk], Tbl_MasterReviewRecord.GlobalChk = [Tbl_ReviewRecord]![GlobalChk], Tbl_MasterReviewRecord.IntlgtChk = [Tbl_ReviewRecord]![IntlgtChk], Tbl_MasterReviewRecord.ComChk = [Tbl_ReviewRecord]![ComChk], Tbl_MasterReviewRecord.SelfChk = [Tbl_ReviewRecord]![SelfChk], Tbl_MasterReviewRecord.ThinkChk = [Tbl_ReviewRecord]![ThinkChk], Tbl_MasterReviewRecord.TechChk = [Tbl_ReviewRecord]![TechChk]," & _
    " Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], Tbl_MasterReviewRecord.9Block = [Tbl_ReviewRecord]![9Block], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _
    " Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves]," & _
    " Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves], Tbl_MasterReviewRecord.Goal1Text = [Tbl_ReviewRecord]![Goal1Text], Tbl_MasterReviewRecord.Goal2Text = [Tbl_ReviewRecord]![Goal2Text], Tbl_MasterReviewRecord.Goal3Text = [Tbl_ReviewRecord]![Goal3Text], Tbl_MasterReviewRecord.Goal4Text = [Tbl_ReviewRecord]![Goal4Text], Tbl_MasterReviewRecord.Goal5Text = [Tbl_ReviewRecord]![Goal5Text], Tbl_MasterReviewRecord.Goal6Text = [Tbl_ReviewRecord]![Goal6Text], Tbl_MasterReviewRecord.Goal7Text = [Tbl_ReviewRecord]![Goal7Text], Tbl_MasterReviewRecord.Goal8Text = [Tbl_ReviewRecord]![Goal8Text]," & _
    " Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]," & _
    " Tbl_MasterReviewRecord.FocusG = [Tbl_ReviewRecord]![FocusG], Tbl_MasterReviewRecord.LeadG = [Tbl_ReviewRecord]![LeadG], Tbl_MasterReviewRecord.ResultsG = [Tbl_ReviewRecord]![ResultsG], Tbl_MasterReviewRecord.PeopleG = [Tbl_ReviewRecord]![PeopleG], Tbl_MasterReviewRecord.ChampG = [Tbl_ReviewRecord]![ChampG], Tbl_MasterReviewRecord.FosterG = [Tbl_ReviewRecord]![FosterG], Tbl_MasterReviewRecord.GlobalG = [Tbl_ReviewRecord]![GlobalG], Tbl_MasterReviewRecord.IntlgtG = [Tbl_ReviewRecord]![IntlgtG], Tbl_MasterReviewRecord.ComG = [Tbl_ReviewRecord]![ComG], Tbl_MasterReviewRecord.SelfG = [Tbl_ReviewRecord]![SelfG], Tbl_MasterReviewRecord.ThinkG = [Tbl_ReviewRecord]![ThinkG], Tbl_MasterReviewRecord.TechG = [Tbl_ReviewRecord]![TechG], Tbl_MasterReviewRecord.MRR = [Tbl_ReviewRecord]![MRR]," & _
    " WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"
    Parsed:

    First of all, I just want to say that this forum is awesome. You guys always give the the solution I am looking for.

    Basically I am receiving the above error (3144), here is all the code it is highlighting. Any help would be appreciated!!!



    Code:
    DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _
    " SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID]," & _
    " Tbl_MasterReviewRecord.Goal1Chk = [Tbl_ReviewRecord]![Goal1Chk], Tbl_MasterReviewRecord.Goal2Chk = [Tbl_ReviewRecord]![Goal2Chk],
     Tbl_MasterReviewRecord.Goal3Chk = [Tbl_ReviewRecord]![Goal3Chk], Tbl_MasterReviewRecord.Goal4Chk = [Tbl_ReviewRecord]![Goal4Chk], 
    Tbl_MasterReviewRecord.Goal5Chk = [Tbl_ReviewRecord]![Goal5Chk], Tbl_MasterReviewRecord.Goal6Chk = [Tbl_ReviewRecord]![Goal6Chk], 
    Tbl_MasterReviewRecord.Goal7Chk = [Tbl_ReviewRecord]![Goal7Chk], Tbl_MasterReviewRecord.Goal8Chk = [Tbl_ReviewRecord]![Goal8Chk]," & _
    " Tbl_MasterReviewRecord.FocusChk = [Tbl_ReviewRecord]![FocusChk], Tbl_MasterReviewRecord.LeadChk = [Tbl_ReviewRecord]![LeadChk], 
    Tbl_MasterReviewRecord.ResultsChk = [Tbl_ReviewRecord]![ResultsChk], Tbl_MasterReviewRecord.PeopleChk = [Tbl_ReviewRecord]![PeopleChk], 
    Tbl_MasterReviewRecord.ChampChk = [Tbl_ReviewRecord]![ChampChk], Tbl_MasterReviewRecord.FosterChk = [Tbl_ReviewRecord]![FosterChk], 
    Tbl_MasterReviewRecord.GlobalChk = [Tbl_ReviewRecord]![GlobalChk], Tbl_MasterReviewRecord.IntlgtChk = [Tbl_ReviewRecord]![IntlgtChk], 
    Tbl_MasterReviewRecord.ComChk = [Tbl_ReviewRecord]![ComChk], Tbl_MasterReviewRecord.SelfChk = [Tbl_ReviewRecord]![SelfChk], 
    Tbl_MasterReviewRecord.ThinkChk = [Tbl_ReviewRecord]![ThinkChk], Tbl_MasterReviewRecord.TechChk = [Tbl_ReviewRecord]![TechChk]," & _
    " Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], 
    Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], 
    Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], 
    Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], 
    Tbl_MasterReviewRecord.9Block = [Tbl_ReviewRecord]![9Block], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _
    " Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], 
    Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], 
    Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves]," & _
    " Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves], Tbl_MasterReviewRecord.Goal1Text = [Tbl_ReviewRecord]![Goal1Text],
     Tbl_MasterReviewRecord.Goal2Text = [Tbl_ReviewRecord]![Goal2Text], Tbl_MasterReviewRecord.Goal3Text = [Tbl_ReviewRecord]![Goal3Text], 
    Tbl_MasterReviewRecord.Goal4Text = [Tbl_ReviewRecord]![Goal4Text], Tbl_MasterReviewRecord.Goal5Text = [Tbl_ReviewRecord]![Goal5Text], 
    Tbl_MasterReviewRecord.Goal6Text = [Tbl_ReviewRecord]![Goal6Text], Tbl_MasterReviewRecord.Goal7Text = [Tbl_ReviewRecord]![Goal7Text], 
    Tbl_MasterReviewRecord.Goal8Text = [Tbl_ReviewRecord]![Goal8Text]," & _
    " Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], 
    Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], 
    Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]," & _
    " Tbl_MasterReviewRecord.FocusG = [Tbl_ReviewRecord]![FocusG], Tbl_MasterReviewRecord.LeadG = [Tbl_ReviewRecord]![LeadG], 
    Tbl_MasterReviewRecord.ResultsG = [Tbl_ReviewRecord]![ResultsG], Tbl_MasterReviewRecord.PeopleG = [Tbl_ReviewRecord]![PeopleG], 
    Tbl_MasterReviewRecord.ChampG = [Tbl_ReviewRecord]![ChampG], Tbl_MasterReviewRecord.FosterG = [Tbl_ReviewRecord]![FosterG], 
    Tbl_MasterReviewRecord.GlobalG = [Tbl_ReviewRecord]![GlobalG], Tbl_MasterReviewRecord.IntlgtG = [Tbl_ReviewRecord]![IntlgtG], 
    Tbl_MasterReviewRecord.ComG = [Tbl_ReviewRecord]![ComG], Tbl_MasterReviewRecord.SelfG = [Tbl_ReviewRecord]![SelfG], 
    Tbl_MasterReviewRecord.ThinkG = [Tbl_ReviewRecord]![ThinkG], Tbl_MasterReviewRecord.TechG = [Tbl_ReviewRecord]![TechG], 
    Tbl_MasterReviewRecord.MRR = [Tbl_ReviewRecord]![MRR]," & _
    " WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    do you really expect someone to parse that out so it's readable??

    how about doing it for us?

  3. #3
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    Oops, sorry about that. Is that any better now?

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    no Ryan, it's not. But to tell you the truth, I don't think I've ever seen an sql statement that long before. Especially one that calls form values. Personally, the only way I would even attempt to read it is if you parsed it out so there's no horizontal scrollbar in the window, and all of the lines were double spaces. It's simply too long to be looked at.

    others might help as it is now, but I will not. If you're posting this only because you're buggy eyed for the day, perhaps it would be better to come back to it tomorrow after you've gotten some rest??

  5. #5
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    first: does the SQL instruction work when using it directly from within the Access query window?
    second: when getting values from combo boxes it often happens Access looks upon them as text fields, even when numbers are used. So for fields like the year-field it could help to use the Clng convert function.

    greetings
    NG

  6. #6
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    Found it, turns out "line 35" I needed to delete the last comma:
    Code:
    Tbl_MasterReviewRecord.MRR = [Tbl_ReviewRecord]![MRR]," & _
    Now, unfortunately I am having trouble with the second part, I get "Run-time error '3075' Syntax error (missing operator) in query expression 'Tbl_ReviewRecord.9Block'.

    Code:
    'APPENDS NEW REVIEWS TO THE MASTER FILE ON THE  SECURED SHARED DRIVE - UPDATES ONLY FOR SPECIFIED INTERVAL, YEAR, &  TL FROM THE ADMIN FORM
    DoCmd.RunSQL "INSERT INTO  Tbl_ReviewRecord ( EID, [Year], [Interval], TL_EID, OM_EID, Badge,  JobCd, JobDesc, Goal1Chk, Goal2Chk, Goal3Chk, Goal4Chk, Goal5Chk,  Goal6Chk, Goal7Chk, Goal8Chk, FocusChk, LeadChk, ResultsChk, PeopleChk,  ChampChk, FosterChk, GlobalChk, IntlgtChk, ComChk, SelfChk, ThinkChk,  TechChk, Prod_Speed, Quality, Safety, Innovation, Commitment, Conduct,  Attendance, Teamwork, 9Block, Dept_Comments, Above_Comments,  Below_Comments, Gen_Comments, Next_Moves, Goal1Text, Goal2Text,  Goal3Text, Goal4Text, Goal5Text, Goal6Text, Goal7Text, Goal8Text,  Writeup, FocusG, LeadG, ResultsG, PeopleG, ChampG, FosterG, GlobalG,  IntlgtG, ComG, SelfG, ThinkG, TechG, Cell, MRR) IN  '\\az18stns04\shared2\PhxRO_Reviews\backups\test\Review Database 9 Block.mdb'" & _
    "  SELECT Tbl_ReviewRecord.EID, Tbl_ReviewRecord.Year,  Tbl_ReviewRecord.Interval, Tbl_ReviewRecord.TL_EID,  Tbl_ReviewRecord.OM_EID, Tbl_ReviewRecord.Goal1Chk,  Tbl_ReviewRecord.Goal2Chk, Tbl_ReviewRecord.Goal3Chk,  Tbl_ReviewRecord.Goal4Chk, Tbl_ReviewRecord.Goal5Chk,  Tbl_ReviewRecord.Goal6Chk, Tbl_ReviewRecord.Goal7Chk,  Tbl_ReviewRecord.Goal8Chk, Tbl_ReviewRecord.FocusChk,  Tbl_ReviewRecord.LeadChk, Tbl_ReviewRecord.ResultsChk,  Tbl_ReviewRecord.PeopleChk, Tbl_ReviewRecord.ChampChk,  Tbl_ReviewRecord.FosterChk, Tbl_ReviewRecord.GlobalChk,  Tbl_ReviewRecord.IntlgtChk, Tbl_ReviewRecord.ComChk,  Tbl_ReviewRecord.SelfChk, Tbl_ReviewRecord.ThinkChk,  Tbl_ReviewRecord.TechChk," & _
    "  Tbl_ReviewRecord.Prod_Speed, Tbl_ReviewRecord.Quality,  Tbl_ReviewRecord.Safety, Tbl_ReviewRecord.Innovation,  Tbl_ReviewRecord.Commitment, Tbl_ReviewRecord.Conduct,  Tbl_ReviewRecord.Attendance, Tbl_ReviewRecord.Teamwork,  Tbl_ReviewRecord.9Block, Tbl_ReviewRecord.Dept_Comments, Tbl_ReviewRecord.Above_Comments, Tbl_ReviewRecord.Below_Comments,  Tbl_ReviewRecord.Gen_Comments, Tbl_ReviewRecord.Next_Moves,  Tbl_ReviewRecord.Goal1Text, Tbl_ReviewRecord.Goal2Text,  Tbl_ReviewRecord.Goal3Text, Tbl_ReviewRecord.Goal4Text,  Tbl_ReviewRecord.Goal5Text, Tbl_ReviewRecord.Goal6Text,  Tbl_ReviewRecord.Goal7Text, Tbl_ReviewRecord.Goal8Text,  Tbl_ReviewRecord.Cell, Tbl_ReviewRecord.JobCd, Tbl_ReviewRecord.JobDesc,  Tbl_ReviewRecord.Badge, Tbl_ReviewRecord.Writeup,  Tbl_ReviewRecord.FocusG, Tbl_ReviewRecord.LeadG,  Tbl_ReviewRecord.ResultsG, Tbl_ReviewRecord.PeopleG,  Tbl_ReviewRecord.ChampG, Tbl_ReviewRecord.FosterG,  Tbl_ReviewRecord.GlobalG, Tbl_ReviewRecord.IntlgtG,  Tbl_ReviewRecord.ComG," & _
    " Tbl_ReviewRecord.SelfG, Tbl_ReviewRecord.ThinkG, Tbl_ReviewRecord.TechG, Tbl_ReviewRecord.MRR" & _
    " FROM Tbl_ReviewRecord;"
    DoCmd.SetWarnings True
    MsgBox "Upload completed successfully.", vbOKOnly

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Just briefly looked at your code and it seems your Select doesn't match your Insert.
    You are inserting into these fields ....
    Badge, JobCd, JobDesc,

    but you have not allowed for these in your select statement.

    I did not go thru all the fields but I noticed that these were unmatched (at least the names don't look like what you intended to do).

  8. #8
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    Wow, very good catch Orange! I copied the line from an earlier code and must not have verified it...Now they all match but I still receive the same exact error code...

    Code:
    'APPENDS NEW REVIEWS TO THE MASTER FILE ON THE  SECURED SHARED DRIVE - UPDATES ONLY FOR SPECIFIED INTERVAL, YEAR, &  TL FROM THE ADMIN FORM
    DoCmd.RunSQL "INSERT INTO  Tbl_ReviewRecord ( EID, [Year], [Interval], TL_EID, OM_EID, Goal1Chk,  Goal2Chk, Goal3Chk, Goal4Chk, Goal5Chk, Goal6Chk, Goal7Chk, Goal8Chk,  FocusChk, LeadChk, ResultsChk, PeopleChk, ChampChk, FosterChk,  GlobalChk, IntlgtChk, ComChk, SelfChk, ThinkChk, TechChk, Prod_Speed,  Quality, Safety, Innovation, Commitment, Conduct, Attendance, Teamwork,  9Block, Dept_Comments, Above_Comments, Below_Comments, Gen_Comments,  Next_Moves, Goal1Text, Goal2Text, Goal3Text, Goal4Text, Goal5Text,  Goal6Text, Goal7Text, Goal8Text, Cell, JobCd, JobDesc, Badge, Writeup,  FocusG, LeadG, ResultsG, PeopleG, ChampG, FosterG, GlobalG, IntlgtG,  ComG, SelfG, ThinkG, TechG, MRR) IN '\\az18stns04\shared2\PhxRO_Reviews\backups\test\Review Database 9 Block.mdb'" & _
    "  SELECT Tbl_ReviewRecord.EID, Tbl_ReviewRecord.Year,  Tbl_ReviewRecord.Interval, Tbl_ReviewRecord.TL_EID,  Tbl_ReviewRecord.OM_EID, Tbl_ReviewRecord.Goal1Chk,  Tbl_ReviewRecord.Goal2Chk, Tbl_ReviewRecord.Goal3Chk,  Tbl_ReviewRecord.Goal4Chk, Tbl_ReviewRecord.Goal5Chk,  Tbl_ReviewRecord.Goal6Chk, Tbl_ReviewRecord.Goal7Chk,  Tbl_ReviewRecord.Goal8Chk, Tbl_ReviewRecord.FocusChk,  Tbl_ReviewRecord.LeadChk, Tbl_ReviewRecord.ResultsChk,  Tbl_ReviewRecord.PeopleChk, Tbl_ReviewRecord.ChampChk,  Tbl_ReviewRecord.FosterChk, Tbl_ReviewRecord.GlobalChk,  Tbl_ReviewRecord.IntlgtChk, Tbl_ReviewRecord.ComChk,  Tbl_ReviewRecord.SelfChk, Tbl_ReviewRecord.ThinkChk,  Tbl_ReviewRecord.TechChk," & _
    "  Tbl_ReviewRecord.Prod_Speed, Tbl_ReviewRecord.Quality,  Tbl_ReviewRecord.Safety, Tbl_ReviewRecord.Innovation,  Tbl_ReviewRecord.Commitment, Tbl_ReviewRecord.Conduct,  Tbl_ReviewRecord.Attendance, Tbl_ReviewRecord.Teamwork,  Tbl_ReviewRecord.9Block, Tbl_ReviewRecord.Dept_Comments, Tbl_ReviewRecord.Above_Comments, Tbl_ReviewRecord.Below_Comments,  Tbl_ReviewRecord.Gen_Comments, Tbl_ReviewRecord.Next_Moves,  Tbl_ReviewRecord.Goal1Text, Tbl_ReviewRecord.Goal2Text,  Tbl_ReviewRecord.Goal3Text, Tbl_ReviewRecord.Goal4Text,  Tbl_ReviewRecord.Goal5Text, Tbl_ReviewRecord.Goal6Text,  Tbl_ReviewRecord.Goal7Text, Tbl_ReviewRecord.Goal8Text,  Tbl_ReviewRecord.Cell, Tbl_ReviewRecord.JobCd, Tbl_ReviewRecord.JobDesc,  Tbl_ReviewRecord.Badge, Tbl_ReviewRecord.Writeup,  Tbl_ReviewRecord.FocusG, Tbl_ReviewRecord.LeadG,  Tbl_ReviewRecord.ResultsG, Tbl_ReviewRecord.PeopleG,  Tbl_ReviewRecord.ChampG, Tbl_ReviewRecord.FosterG,  Tbl_ReviewRecord.GlobalG, Tbl_ReviewRecord.IntlgtG,  Tbl_ReviewRecord.ComG," & _
    " Tbl_ReviewRecord.SelfG, Tbl_ReviewRecord.ThinkG, Tbl_ReviewRecord.TechG, Tbl_ReviewRecord.MRR" & _
    " FROM Tbl_ReviewRecord;"
    DoCmd.SetWarnings True
    MsgBox "Upload completed successfully.", vbOKOnly

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I just saw your post and reviewed it again. It appears that the Inserts and selects are all matched up.

    What exactly is the message you are getting?

    Also it appears you are suppressing the messages (confirmations) from the DoCmd.runsql It is possible there is an error being sent but since Warnings are Off, you could be missing something... just a thought.

  10. #10
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    The exact message I am getting are as follows:

    Run-Time error '3075':

    Syntax error (missing operator) in query expression
    'Tbl_ReviewRecord.9Block'.



    What do you recommend for the "warnings" being off?

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Is the field/column name spelled correctly--- 9Block?
    It is possible when editing or copying a text that some hidden characters may be embedded in the text. You could copy it again and check in an editor program that no special characters exist.
    I don't see anything obvious in the SQL to cause the error.
    Let us know what you find.

    With action queries you can replace DoCmd.RunSQL with
    db.execute YourSQL,dbFailOnError
    This will not prompt you to OK the Insertion of records, but it will pass errors to an error routine.

  12. #12
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    I still can't figure this one out...

    Per your recommendation
    -The column name is spelled correctly, couldnt find any spelling issues for 9Block
    -Copied the text into an editor program and ensured no special characters exist

    Still can't figure it out and I still receive the same error message.

    Any thoughts?

    Edit: when I remove the two pieces of "9Block" code, the database updates correctly....I just cant figure this one out!

    Maybe it has something to do with the column being labeled with a number in the front?

  13. #13
    KrenzyRyan is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    54
    K, figured this one out, looks like it was the cause of having a 9 or numeric character in the beginning. I changed the Spelling to just "block" and it fixed everything. Kind of strange.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-23-2010, 09:11 AM
  2. NEW sql update HELP :( (time field problem)
    By ducthang88 in forum Programming
    Replies: 1
    Last Post: 12-05-2010, 12:03 AM
  3. Replies: 2
    Last Post: 12-02-2010, 02:35 AM
  4. Update a combo box in real time
    By protean_being in forum Forms
    Replies: 0
    Last Post: 05-17-2008, 07:39 AM
  5. Replies: 1
    Last Post: 12-09-2005, 09:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums