+ Reply to Thread
Results 1 to 1 of 1

Runtime Error 80040e10 Excel VBA MS Access

  1. #1
    Registered User
    Join Date
    03-08-2005
    Posts
    1

    Runtime Error 80040e10 Excel VBA MS Access

    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).

    Please Login or Register  to view this content.
    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
    Last edited by cnerurkar; 02-26-2007 at 10:41 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1