12-09-2009, 03:21 AM #5 missinglinq AWF VIP Join Date: Jun 2003 Location: Richmond (Virginia that see here Hard to say without seeing your full code, could be as simpel as an uncomment RunCommand, like: Code: 'Currentdb.Execute strSQL.... Remove the extra comma, but I don't think it will run as you expect, do a Debug.Print of the SQL before you execute is also a good idea. Close this window and log in. Ms Access Runtime Error

Just to give you some idee, in your value fields you must wrap every field correctly. The code is as follows: Private Sub cmdImportMaterials_Click() '--------------------------------------------------------------------------------------- ' Procedure : cmdImportMaterials_Click ' Author : kelly ' Date : 26/05/2014 ' Purpose : Import materials to the current task from The guy that worked on this originally set up those names. http://axisnice.com/time-error/access-2003-runtime-error-3265.php Quote: Also note that If Me.unbOrderedBy = "" Then is not going to tell you if the field is blank.

The code works importing records for the first table but gives me the error for the second table. Ms Access Runtime Error 13 Type Mismatch Here is the code: Private Sub cmdAdd_Click() DBEngine.BeginTrans CurrentDb.Execute "INSERT into Names(StudentId, FirstName, MiddleName, LastName) VALUES (" & Me.txtStudentId & ",'" & _ Me.txtFirstName & "','" & Me.txtMiddleName & "','" & RE: Runtime Error 3134 Syntax Error in INSERT INTO statement MazeWorX (IS/IT--Management) 14 Feb 12 03:16 Ace you are correct 'Note' is a reserved word in 2002-2003.

JR JANR View Public Profile Find More Posts by JANR 12-09-2009, 08:49 AM #8 ASherbuck Newly Registered User Join Date: Feb 2008 Location: PA

Join them; it only takes a minute: Sign up Runtime Error 3134 - Syntax Error in INSERT INTO Statement (MS Access VBA) up vote 0 down vote favorite I changed the Again, thanks for your help as I dip my feet in the SQL water! Registration on or use of this site constitutes acceptance of our Privacy Policy. Ms Access Runtime Error 2105 Join them; it only takes a minute: Sign up VBA Error 3134 Syntax error in INSERT INTO statement up vote 2 down vote favorite I have taken on supporting/upgrading a MS

for easy reading. Page 1 of 2 1 2 > Thread Tools Rating: Display Modes 12-08-2009, 12:09 PM #1 AccessNewbie73 Newly Registered User Join Date: Dec 2009 Posts: 5 Thanks: 0 sql vba ms-access access-vba share|improve this question edited Nov 7 '13 at 17:11 HansUp 79.1k114371 asked Nov 7 '13 at 16:16 user2957005 612 Is "Name-Homeroom_Primary_Teacher" really a column name? Get More Info Well spoken, large Insert statements should be avoided it to easy to get the order or syntax wrong.

For those interested here is a list of reserved words from MS http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" Connect with top rated Experts 15 Experts available now in Live!