Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 22nd, 2003, 08:23 PM
Registered User
 
Join Date: Aug 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA v. VB

Is it a fair statement to say that if you know VBA fairly well you practically know VB also?

 
Old August 22nd, 2003, 08:26 PM
Authorized User
 
Join Date: Jun 2003
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, it is a fair statement. As far as i know, differences are minor.

Vladimir
 
Old August 22nd, 2003, 10:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

At the level of language syntax, data types, etc. they are indeed very similar. VBA is, essentially, a subset of the VB language, and both use the MSVBVMx0.dll.

Two annoying differences:

1. VBA doesn't support control arrays.
2. VBA doesn't suppprt user-defined events in classes using
   WithEvents and therefore isn't as well suited to object-oriented
   programming.

Finally, you really can't think of VB apart from the VB Development Environment, and VB obviously supports a much broader range of projects than VBA, such as ActiveX EXE's and ActiveX DLL's. Therefore, you think differently about developing an application in VB than you do in VBA. For example, I tend to make much heavier use of classes in VB which get compiled into custom DLL's that can frequently be referenced by a variety of applications. With VBA, you're constrained by the object model and environment of the particular application you are developing for. So the whole application design, compilation, packaging, deployment picture is very different. I would consider knowing about these broader application development issues part of what it means to "know VB" (though I also understand that your question was probably asked at the level of language similarities).

Bob






Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA, VB, VB.NET,...??? jumpjack Visual Basic 2005 Basics 2 September 24th, 2007 02:52 PM
Comparison between VB and VBA gedgriffiths VB How-To 1 April 16th, 2007 12:22 PM
VB & VBA vin_0x1 Pro VB 6 0 April 7th, 2006 04:57 AM
adding VBA code to VB jamie123 VB How-To 1 April 27th, 2004 02:27 AM
KeyPress Event in VB different from VBA PaulG Beginning VB 6 3 February 3rd, 2004 01:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.