Difference between VBA and VB 6.0

[Guest]

Hi,

I am pretty new to VB. Can anyone let me what is the diference between VBA
and VB 6.0.

I have an old access database which is in very bad condition with no primary
key or normalization on the tables. The controls on the forms exceeded the
limit and can't add any more new fields.

I have to redesign this old database by overcoimng all the limitations it
has. So I planning to get some training. But I get confused which classes to
take between VB 6.0 and Access 2003. I dont see any training classes
available on particularly VBA, instead I have on ACCESS 2003 which might not
include traing in VBA. Can anyone please advise me on this.

Thanks.

 

[John W. Vinson]

Hi,

I am pretty new to VB. Can anyone let me what is the diference between VBA
and VB 6.0.

I have an old access database which is in very bad condition with no primary
key or normalization on the tables. The controls on the forms exceeded the
limit and can't add any more new fields.

I have to redesign this old database by overcoimng all the limitations it
has. So I planning to get some training. But I get confused which classes to
take between VB 6.0 and Access 2003. I dont see any training classes
available on particularly VBA, instead I have on ACCESS 2003 which might not
include traing in VBA. Can anyone please advise me on this.

Thanks.

The object models are *very* different between VB 6.0 and VBA. The language
syntax is very similar, and VB6 training would not be wasted if you're
currently not comfortable with programming languages in general - but (just as
an example) a Form or a Listbox in Access is a very different object than the
object of the same name in Access.

There are good resources on VBA; any good intermediate to advanced Access2003
course *should* at least contain an introduction to it. There are also good
books and other resources for self-teaching; anything by John Viescas is a
good choice. For others, see


John W. Vinson [MVP]

 

[John W. Vinson]

oops!!! Sorry. Premature Send click: references

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]

 

[Guest]

oops!!! Sorry. Premature Send click: references

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]

Thanks for all the info.

 

[Larry Linson]

John,

Within the last year, prior to release of Access 2007, I was researching for
a client the availability of good (commercial) Access training from
reputable vendors. I was both astonished and dismayed to find that the two
that came to my mind most readily had not updated their Access training
since Access 2000. I would hope that they haven't just "written off" Access
training as "not worth their while" but were only waiting for the "big
changes" in Access 2007. Of course, some of the most popular of the Access
trainers of the past have moved on to the "world of DotNet", so there may
well be new trainers featured in the new training material.

The new WROX book, "Access 2007 VBA Programmer's Reference" by Teresa
Hennig, Rob Cooper, Geoffrey L. Griffith, and Armen Stein (will be out in
Paperback on May 7, 2007, according to the Amazon site). Knowing Teresa and
Armen, I have no doubt that it will be well-done and helpful to someone
wanting to learn VBA for use in Access.

The Access 2003 edition of the same title, by Patricia Cardoza, Teresa
Hennig, Graham Seach, and Armen Stein is currently available. I've begun to
review it, and have been pleased with what I have read.

Larry Linson
Microsoft Access MVP