Visual Basic Access - recording information from Textboxes

Question

I'm trying to create a form that allows you to register users. I've looked up tutorials and none of them seem to work. This is the code I am stuck with currently:

CurrentDb.Execute "INSERT INTO tblUser(User ID, Fullname, Username, Password, Security) " _ & VALUES & " (" & Me.ID & ",'" & Me.Fullname & "','" & Me.Uname & "','" & _ Me.uPass & "','" & Me.Pri & "')"

When I run the code I get:

Runtime error '3134': Syntax error in INSERT INTO statement.

Instead of executing the statement, print it out and make sure it's valid SQL. That being said...better to use parameterized queries. stackoverflow.com/questions/17678856/… — Eric Yang
– Eric Yang, Commented Aug 4, 2018 at 1:28
VALUE there should be a string ("VALUE"), not unless it is a variable containing the string "VALUE". — L42
– L42, Commented Aug 4, 2018 at 1:59

Han · Accepted Answer · 2018-08-04 02:05:27Z

Two errors:

You have space in one of your field. Use brackets if you have space or if you use reserved words.
VALUES must be included in the string, not as a varible.

Correction:

CurrentDb.Execute "INSERT INTO tblUser([User ID], Fullname, Username, Password, Security) " & _ "VALUES (" & Me.ID & ",'" & Me.Fullname & "','" & Me.Uname & "','" & _ Me.uPass & "','" & Me.Pri & "')"

L42 · Accepted Answer · 2018-08-04 02:01:33Z

From my comment, try below:

CurrentDb.Execute "INSERT INTO tblUser(User ID, Fullname, Username, Password, Security) " _ & "VALUES(" & Me.ID & ",'" & Me.Fullname & "','" & Me.Uname & "','" & _ Me.uPass & "','" & Me.Pri & "')"

Gustav · Accepted Answer · 2018-08-04 05:04:53Z

Password is a reserved word, so:

CurrentDb.Execute "INSERT INTO tblUser(User ID, Fullname, Username, [Password], Security) " _

Collectives™ on Stack Overflow

Visual Basic Access - recording information from Textboxes

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related