Solved

Difference between Access 2007 vba and Access 2013 vba

Posted on 2014-11-22
10
454 Views
Last Modified: 2014-11-22
Hello,  I am getting back into database development after about 10 years hiatus.  I have a book on Access 2007 vba that I find easy to use.  Will it still be helpful for working in Access 2013 or is it outdated?
0
Comment
Question by:Saleve
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40459116
If you're going to be working in WebApps that 2007 book would not be useful at all. Those concepts were introduced in 2010, and heavily refined in 2013.

If you're sticking with desktop stuff, then the content of the 2007 book would be relevant, but of course anything added in 2010 and 2013 would not be there. For example, DataMacros were added to 2010, so you wouldn't have any reference to that. DataMacros aren't VBA, but they are an important addition to Access.

But there's lots of online stuff that can help you with 2013, and of course you have EE :)
0
 

Author Closing Comment

by:Saleve
ID: 40459281
I love EE!  Thanks!
0
 
LVL 57
ID: 40459437
As Scott said, on the desktop side, not much has changed, but one change to be aware of is that Access 2010 and up use VBA7, not VBA6, the most significant (and really just about the only changes) is that it supports 64 bit/

If your using 3rd party controls or windows API controls and have a user with 64 bit Office installed, you need to account for that as all calls will be made in 64 bit.

Jim.
0
 

Author Comment

by:Saleve
ID: 40459468
Thanks, Jim.  I'm going to be making a fairly basic desktop database that isn't going to interact with anything outside of Access.   If I code according to what I read in a book about Access 2007 vba, can I be sure not to have problems  as a result of the change to 64 bit?
Saleve
0
 
LVL 57
ID: 40459486
Saleve,

  Pretty much.  Where you'd run into a difference between 32 and 64 bit's are:

1. Third party controls, DLL's, or references - If your not touching the reference list in VBA, then no problem.

2. Windows API calls - Getting the current user name, etc.

3. ODBC calls - if your using data sources in something like at SQL BE.    Here it's not the app that would change, but if you had a user with 64 bit Office, then 64 bit ODBC drivers for the data source will be required.

The one problem you might have is distributing as a ACCDE.  Since the source is stripped out, it cannot be re-compiled on the fly to work in both 32 and 64 bit.   If you plan to distribute this way, then you'll two versions.

If you distribute as a ACCDB, then you only need one version and it would work for either 32 or 64 bit users outside of what I mentioned above.

Jim.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:Saleve
ID: 40459491
I will make sure to distribute as an ACCDB.  Thanks again!
Saleve
0
 
LVL 75
ID: 40459845
Let me highly recommend this book:

Access 2013 Inside Out by Jeff Conrad

Everything you need to know about A2013 Web Apps and the Desktop. And endless number of sample Web Apps and Desktop database can be download, as well as the 100% searchable eBook PDF.  
I have personally met Jeff (works for Microsoft) many times and his passion for Access is second to none,

mx
0
 

Author Comment

by:Saleve
ID: 40459852
Thanks mx!!!  I'll look for it :-).
0
 
LVL 75
ID: 40460022
Amazon :-)
0
 

Author Comment

by:Saleve
ID: 40460024
I'm on it (tomorrow)!  Now it's time for bed.  A bientot!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now