Skip to main content
A
Abdlah
Inspiring
July 29, 2008
Answered

Insert Error

  • July 29, 2008
  • 2 replies
  • 544 views
have an access database with all the fields but PRICE (which is defined as currency) as text and when I submit the values from my form I receive an error (error information is attached in code section). What is it I am doing wrong?
This topic has been closed for replies.
Correct answer Magikaru
You're missing a closing parenthesis for Values.

2 replies

M
MagikaruCorrect answer
Inspiring
July 29, 2008
You're missing a closing parenthesis for Values.
D
Dan_Bracuk
Inspiring
July 29, 2008
Step 1 - get rid of the brackets surrounding your form variables.

Step 2 - if Step 1 doesn't work. Comment out all but the last fieldname and value and try your insert query. If it works, uncomment them one by one until it fails. Then you'll know what the problem field is. My guess is that it would be price, because of the datatype.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices