I just found that Name and Number or one of those were pre-defined names in Access causing my problem.
Thanks for the help.
User Profile
Collapse
-
I have tried using the code above, still the same syntax error appears.
What else can I check?Leave a comment:
-
Adding item in Database
Hi there. I have a simple Access database with names and numbers.
I'm trying to add another entry through vb6 but i get a SYNTAX ERROR in INSERT INTO statement.
Please help. What am i doing wrong?
Private Sub cmdAdd_Click()
Dim sql, nam, num As String
nam = InputBox("Enter Name:", "Name")
num = InputBox("Enter Number:", "Number")...
No activity results to display
Show More
Leave a comment: