-
May 13th, 2011, 10:14 AM
#1
Thread Starter
New Member
[RESOLVED] Runtime Error 3134 - Syntax Error in INSERT INTO Statement
Hello all,
First time poster here. I have worked with VB6 in the past but am a little rusty. My employer gave me a database (already partially constructed) to work on in my free time. I am using MS Access 2007. My current issue is with the following code which executes on a button click on an unbound form:
Code:
Private Sub Command44_Click()
Dim query1 As String
query1 = "INSERT INTO User (Last Name, First Name, User name, Location, " & _
"Staff ID, Email1, Email2, Nickname, Address, City, State, Zip, Home Phone, " & _
"Cell Phone, Notes) VALUES ('" & Me!LastName.Value & "', '" & Me!FirstName.Value _
& "', '" & Me!Username.Value & "', '" & Me!Location.Value & "', '" & Me!StaffID.Value _
& "', '" & Me!Email1.Value & "', '" & Me!Email2.Value & "', '" & Me!Nickname.Value _
& "', '" & Me!Address.Value & "', '" & Me!City.Value & "', '" & Me!State.Value _
& "', " & Me!Zip.Value & ", " & Me!HomePhone.Value & ", " & Me!CellPhone.Value _
& ", '" & Me!Notes.Value & "');"
Debug.Print query1
DoCmd.RunSQL query1
End Sub
The results of the Debug.Print statement are:
Code:
INSERT INTO User (Last Name, First Name, User name, Location, Staff ID, Email1, Email2, Nickname, Address, City, State, Zip, Home Phone, Cell Phone, Notes) VALUES ('Smith', 'John', 'jsmith', 'MHS', 'JK38471', 'jsmith@blah.com', 'smithj@blargh.edu', 'Jonny', '465 Anywhere St.', 'Anytown', 'AK', 48654, 4564564565, 6548651388, 'Notes about his man…');
Upon clicking the button I am getting the error in the title:
Runtime Error 3134 - Syntax Error in INSERT INTO Statement
I have looked around and have been unable to find an answer to the problem. Any help would be greatly appreciated.
~Wiggz
-
May 13th, 2011, 10:41 AM
#2
Re: Runtime Error 3134 - Syntax Error in INSERT INTO Statement
You have spaces in the field names. This is a big no no. Since they are already there enclose each field name with a space in it (ie Last Name) in square bracketes like this [Last Name]
Sometimes the Programmer
Sometimes the DBA
Mazz1
-
May 13th, 2011, 10:52 AM
#3
Thread Starter
New Member
Re: Runtime Error 3134 - Syntax Error in INSERT INTO Statement
*sigh* Thanks, that worked. The guy that worked on this originally set up those names. I didn't like having spaces but it would have required a few changes elsewhere. I went ahead and made those changes and it fixed it. Thanks again.
-
May 13th, 2011, 11:00 AM
#4
Re: Runtime Error 3134 - Syntax Error in INSERT INTO Statement
No problem. Happy to have helped. If this resolves your issue could you do us a favor and use the thread toos and mark this as resolved.
Thanks
Sometimes the Programmer
Sometimes the DBA
Mazz1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|