Inster INTO Table Not Working

[AsifShah]

Hello Evory One ... im new in Access please some on help me on Inster into sql commond .. my code is not working.

my code is

Dim strInsert As String

strInsert = "INSERT INTO Users (ID, FirstName, LastName, Password, ConfirmPassword, SecurityQuestion, Designation, Mobile, Answer, Picture)" & _
"values ('" & Me.txtID & "', '" & Me.FirstName & "', '" & Me.LastName & "', '" & Me.Password & "', '" & Me.ConfirmPassword & "', '" & Me.SecurityQuestion & "', '" & Me.Designation & "', '" & Me.Mobile & "', '" & Me.Answer & "', '" & Me.txtPicture & "');"

DoCmd.SetWarnings False
DoCmd.RunSQL strInsert

 

[welshgasman]

You do not say why it is not working?

Start getting used to using Debug.Print

Use that on strInsert and that should show you your error.

 

[Joe4]

One thing that might be a problem - I think you might need a space between ")" and "values".
Note that you can combine this part:

strInsert = "INSERT INTO Users (ID, FirstName, LastName, Password, ConfirmPassword, SecurityQuestion, Designation, Mobile, Answer, Picture)" & _
"values ('"

to this:

strInsert = "INSERT INTO Users (ID, FirstName, LastName, Password, ConfirmPassword, SecurityQuestion, Designation, Mobile, Answer, Picture) values('"

 

[AsifShah]

Thanks Alot Dear

 

[Joe4]

You are welcome.
Glad we were able to help!