locked
AC.2013.VBE.Watches...Unexpected Error (3420) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    AC.2013.VBE.Watches:

    add watch

    CURRENTDB.TableDefs("ZZ_TBL_INI_W1_DFT").Fields ' my table: ZZ_TBL_INI_W1_DFT

    +click, ---> count....<object invalid...

    -click

    +click,........Unexpected Error (3420) iconfused.gif


    dBase,FoxPro,MS Access 2003,(2010=Not rec.),Office 2010+ACC.2013 ,Symbian C++, AC.2013.SystemResource.GetCurrentFreeSize=?

    Thursday, July 30, 2015 11:35 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    >>>CURRENTDB.TableDefs("ZZ_TBL_INI_W1_DFT").Fields  ' my table: ZZ_TBL_INI_W1_DFT

    +click, ---> count....<object invalid...

    -click

    +click,........Unexpected Error (3420)

    CurrentDB is Object Invalid or Not Set Error - It is a METHOD that returns a DIFFERENT POINTER to the underlying database object for EACH INVOCATION of CurrentDB.

    You can declare a db variable then try like below:

    Set db = CurrentDb

Set tblfields = db.TableDefs(tblName).Fields

    Monday, August 3, 2015 2:42 AM