Access 2013 - 2016 RRS feed

  • Question

  • Big problems after upgrade from Access 2013 to 2016. Queries aren't working and some functionality lost. Are ActiveX Controls gone? What is the work around?

    I think these are the other changes...what is the work around?

    Date()  Function

    Today() Function

    Left, right, Instr 


    Thursday, December 6, 2018 1:28 PM

All replies

  • Hi,

    Based on your description, I will move this thread to Access forum:

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.



    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, December 7, 2018 3:08 AM
  • When basic functions such as Date, Left, Right, ... err normally this indicates a VBA Reference issue.  Open the VBE and go into Tools -> References ... and see if any are marked as MISSING and fix them.  Once fixed, compile your VBA project and try again.

    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support:
    MS Access Tips and Code Samples:

    Friday, December 7, 2018 1:20 PM