(Leo) VBA or VB ?

[Guest]

Hi, Experts;
I am very much in need of start learning programming well in MS office
components, especially in Access. I am familiar with VBA fundamentals, but I
feel that I need much more to know to do better qualified jobs. But
unfortuanately I dont have a very thorough reference or tutorial book on VBA,
and it is not possible for me to get a one from Amazon...Instead, a freind of
mine gave me a relatively complete book on VB6.
I feel that the difference between VB and VBA is only their developement
environments. Am I right?
I need to know if I finish studying and practicing this book on VB, can I
become master of VBA as well??
In other word, Does VB stand-alone programming language, cover all topics of
VBA?
thank you for your complete answer in advance.

 

[Nikos Yannacopoulos]

Leo,

I'm afraid the answer is no. VBA has "extensions" for specific
applications, that have to do mostly with handling application-specific
objects and their events. To that extent, Access VBA and Excel VBA, for
example, are different! A VB6 book is a good start to get you into VB
programming in general, but won't make you a master on Access VBA.

HTH,
Nikos

 

[Brian]

Hi, Experts;
I am very much in need of start learning programming well in MS office
components, especially in Access. I am familiar with VBA fundamentals, but I
feel that I need much more to know to do better qualified jobs. But
unfortuanately I dont have a very thorough reference or tutorial book on VBA,
and it is not possible for me to get a one from Amazon...Instead, a freind of
mine gave me a relatively complete book on VB6.
I feel that the difference between VB and VBA is only their developement
environments. Am I right?
I need to know if I finish studying and practicing this book on VB, can I
become master of VBA as well??
In other word, Does VB stand-alone programming language, cover all topics of
VBA?
thank you for your complete answer in advance.

Learning VB6 will help a lot with VBA, but it will not tell you everything.
As programming languages, they are nearly identical, BUT the Access object
and event models are very different from those in VB6.

You will learn a huge amount from searching the web for free tutorials and
studying them.