Hi Guys,
I am trying to update specific fields of table in Ms Access, through Excel VBA. My select and add new record queries work, but the update query always throws the RUN TIME ERROR 80040e10 - "No Value Given To One or More Required Parameters"
I have checked my table name and the other field names over and over again, but I see nothing wrong with the quesry. I am trying to update a few fields from the database, for a existing record number (autonumber).
Could someone point our what I am doing wrong. The error occurs on the statement
VBA:
cnt.open SQLUpdate
ERROR: RUN TIME ERROR: 80040e10 - "No Value Given To One or More Required Parameters"
Thanks.
Regards,
Cnerurkar
Bookmarks