Results 1 to 4 of 4
  1. #1
    Halle is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    4

    Is Access 2007 VBA coding compatible with Access 2013?

    As I Google this question, I see an array of answers. The Access databases on my home computers are from Office 2007/2010. I am now going to be designing a databases on a work computer which has Office 2013. My Access VBA reference books are from Access 2007. I am though still learning VBA coding. At some point will I run into any problems coding in Access 2013 using VBA code from 2007? For Access 2013, do I need to upgrade to a later reference book on VBA coding as shown below?



    Thanks for any help.



    Click image for larger version. 

Name:	869754.jpg 
Views:	25 
Size:	49.9 KB 
ID:	36072

    Click image for larger version. 

Name:	8162V2NPHOL.jpg 
Views:	25 
Size:	97.4 KB 
ID:	36074

    Click image for larger version. 

Name:	91XHug5db7L.jpg 
Views:	25 
Size:	158.4 KB 
ID:	36073

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The basic VBA language has not changed so much at least from 2003 to 2010. I started building a program with 2003, converted to accdb with 2007 and still runs under 2010. I used some old VB6 references to expand VBA skills as vocabulary and syntax is very similar. Helps that I already understood programming concepts and had a 1 on 1 tutor for Access. Picked up a bunch more from internet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    2007 VBA should run in 2013 and beyond - it is backwards compatible. This fell over in certain situations when 2007 was introduced. With the introduction of the ribbon, certain code which managed menu bars would fail and need to be modified to work with the ribbon instead. The important area are the libraries. Code written in 2007 uses a certain version of for example the access object library (think it was 13). Later versions will substitute an earlier library with a later one, but an earlier version will not substitute a later version with an earlier one. The syntax remains the same.

    you might find this link useful which maps the evolution of Access

    https://www.fmsinc.com/microsoftacce...y/features.htm

    You will see certain features available in 2007 are no longer available in 2013

  4. #4
    Halle is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    4
    Thanks guys for both of your replies.

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

Similar Threads

  1. Replies: 6
    Last Post: 10-28-2016, 06:47 AM
  2. Coding Help with ComboBox and Button, Access 2013
    By Slashback115 in forum Programming
    Replies: 14
    Last Post: 09-27-2016, 06:05 PM
  3. Replies: 2
    Last Post: 04-07-2014, 10:01 AM
  4. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  5. Replies: 0
    Last Post: 06-19-2012, 12:39 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