Results 1 to 2 of 2
  1. #1
    Pudsi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2013
    Posts
    2

    Microsoft Visual Basic - Run-time error '2683' - There is no object in this control

    The company I work for use an Access Database that was written in 2009 by a previous employee. No-one in the company, including myself, has ever developed or has any knowledge of MS-Access.



    Half the computers in the Business use MS Office Professional 2013 and half use MS Office Professional 2016.

    Last week, the Access Database began to error on all the computers running Access 2016. Note that the Access Database still works on all the computers running Access 2013.

    The error message is as follows:

    Microsoft Visual Basic

    Run-time error '2683'

    There is no object in this control

    The Access Database crashes on the following line:

    Set oTV = Me!axProducts.Object

    I have attached the form that the above line is a part of.

    I am assuming that this issue reared its ugly head after a MS Office 2016 update (because all the MS Office 2013 computers still run the Database without issue).

    Can anybody help?! I would be eternally grateful!
    Attached Files Attached Files

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm going to guess this is the area that is failing:
    Code:
        
       '*********** NEW Treeview *************
       
        'Dim otved As clsTreeViewEnhDefinition
        Set oTV = Me!axProducts.Object
        Set dbs = CurrentDb()
        Set rstProdType = dbs.OpenRecordset("Select * From qTreeRecordset", dbOpenDynaset) 'MB: replaced qSupplierProducts with qTreeRecordset
        'Set rstProdType = dbs.OpenRecordset("Select * From qSupplierProducts", dbOpenDynaset) 'MB: replaced qSupplierProducts with qTreeRecordset
    
        FillTree
    Does this form have a recordset and is there a firld in this recordset named axProducts and is there anything in that field?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Microsoft Visual Basic for Applications
    By jtradergp13 in forum Access
    Replies: 1
    Last Post: 01-25-2017, 10:30 AM
  2. Replies: 1
    Last Post: 10-01-2014, 06:21 AM
  3. run time error 2683
    By ronni in forum Access
    Replies: 2
    Last Post: 07-18-2014, 10:08 AM
  4. Replies: 3
    Last Post: 07-20-2013, 12:53 PM
  5. microsoft visual basic REFERENCE
    By marianne in forum Access
    Replies: 0
    Last Post: 04-01-2009, 08:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums