0

hello
i started visual basic in access and wnted to use INSERT INTO ,
thats the code:

Dim arr As String
arr = "INSERT INTO customer product(user) VALUES('" & user.Text & "')"

thanks for help

4
Contributors
6
Replies
29
Views
1 Year
Discussion Span
Last Post by jacks009
0

Is you table name actually customer product - 2 words?
If yes, then you'll need to quote it
arr = "INSERT INTO 'customer product'(user) VALUES('" & user.Text & "')"

The INSERT command expects the first name after INSERT INTO to be the table so it doesn't know what to do with the word 'product'

1

hericles , there still a problem

I'm going to need more information than that. If you run the code what error do you get?

0

Capture.PNG
there is writen in hebrew.

Edited by dimabest

0

I was going to copy and paste it into Babbelfish and see what the Hebrew to English translation was, but it's a photo so I can't. For a solution, you'll have to hope someone who reads Hebrew sees this thread.

Or here's a thought. Presumably YOU speak/read/write Hebrew. Maybe YOU can translate it into English.

Edited by AssertNull

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.