VBA started throwing a runtime error recently.

Anand Dixit
over 8 years ago

I have a macro developed for my designing and other billing purpose. I run it from CorelDRAW to write the data to external database. I use Access (.mdb) in the backend as the macro is old and have been using it since X4.

Last few days (about a week or so) it started throwing error 429 and I am unable to use the macro. I am using MS DAO 3.6 Object library reference. I doubt if it started since I installed the latest CorelDRAW hotfix. Though not sure if that's true.

Any help is appreciated.

Parents
No Data
Reply
  • over 8 years ago
    Hi.
    As long as your reference is checked in Tools > Reference,
    Or a reference is declared in the code, ie late binding...

    Comment out your error handling line, example:

    'on error goto ....

    Place the ' in front of the line.
    Run macro. Debugger will stop on problem line.

    Sometimes you will have to declare the library the function comes from before the method because of a clash with a method in another library with same named method.

    Ie.
    VBA.right
    or
    MsForms.Control
    like
    MSDAO.mymethod
Children
No Data

© Corel Corporation. All rights reserved. The content herein is in the form of a personal web log ("Blog") or forum posting. As such, the views expressed in this site are those of the participants and do not necessarily reflect the views of Corel Corporation, or its affiliates and their respective officers, directors, employees and agents. Terms of Use / Privacy​ ​/ ​Cookies / Terms and Conditions / User Guidelines.