John doe
John doe

Reputation: 7

Access - Append query won't append a string input in a texbox form

The form: https://i.sstatic.net/tKgi7.jpg That's where I input the text. The Query: https://i.sstatic.net/a0L3u.jpg The query for some reason does not want to append the strings to the table, it only manages to append the phone number and the ID, and says there's some sort of conversion error which prevents the strings of the name and address from appending. But ClientName and Address are both data types of short text, so they're supposed to accept a string..

Upvotes: 0

Views: 55

Answers (1)

John doe
John doe

Reputation: 7

Problem resolved, I had to use the CStr() function, and it finally worked out somehow.

Upvotes: 0

Related Questions