Member Avatar for dimabest

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
  • 172 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by jacks009
Member Avatar for hericles

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'

Member Avatar for dimabest

hericles ,
there still a problem

Member Avatar for hericles

hericles , there still a problem

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

Member Avatar for dimabest

Capture.PNG
there is writen in hebrew.

Edited by dimabest
Member Avatar for AssertNull

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
Member Avatar for jacks009

Very informative post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.