Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unhappy Unanswered: help with adodc-sql

    hi!

    i need to update my database (ms access) here are the codes that i used:

    (on form load)
    upd = "update translip set tsno = ' ' where code = 'K'"

    (on a command button)
    adotrans.recordsource = upd
    adotrans.refresh

    a dialog box shows up which says: "operation is not allowed when object is closed." the update statement works fine because i placed a "on error resume next statement" , i just keep getting the dialog box.

    i really need all the help i can get.

    thanks!

  2. #2
    Join Date
    May 2004
    Posts
    97
    Remove your "on error" statement and when the program encounters the error it will halt and point to the line with the error. The OBJECT that has a method or property reference is set to null at this point. Quite likely because you opened it in a different procedure and the SCOPE of the object is not valid within this procedure.

Posting Permissions

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