Visual Basic for Access compile error RRS feed

  • Question

  • I have a field of data that was written to a database in the wrong order.  I have a section of code that is supposed to fix the error in every record in a table.

    This code has worked in the past, but when I try to run the code on a current database, it gives me a compile error.  Any ideas of what I might be doing wrong?

    I have attached an image of the code and the error message.

    Wednesday, December 10, 2014 9:24 PM


  • Use the menu Tools / References ... (seen in posted image) to check that you still have "Microsoft ActiveX Data Objects 2.x Library" selected as one of the included References and it is not marked as "MISSING".


    Van Dinh

    Wednesday, December 10, 2014 9:35 PM