Basic Difference between Visual Basic 6 and Microsoft Access VBA

[Irshad Alam]

Could you all please advise me the basic difference between the Visual basic
6 and Microsoft Access VBA.

I am working on Microsoft Access programming from last few years and very
much fimiliar with Access VBA. Now I am planning to start with Visual Basic
6, I have following question in my mind :
a) Will the VBA will give an advantage to understand the Visual Basic 6
programming. b) Will I able to work on Visual Basic 6 easily OR its entirely
different method of programming.
C)Are the objects of Visual basic same like forms,reports,query,table
D) On which web site I am find more information of the basic differences of
both.

Thanking you all for the supports you people provide for the access users.

Regards.

Irshad

 

[Allen Browne]

In reply to your 4 questions:

a) Yes: VB is the same as VBA when it comes to modules, procedures,
variables, loops, branches, operators, and many functions.

b) As above.

c) There is some similarity between VB forms/controls and Access
forms/controls, but they are different in crucial ways. VB forms lack the
core functionality you are used to in Access: e.g.:
- the form's events are different (Dirty, BeforeUpdate);
- the controls are different (e.g. Text verses Value properties);
- VB lacks subforms for handling the related data so easily.

VB lacks the Access reports completely.

It also lacks the table and query design interface Access has.

Building a VB 6 application is therefore a completely different proposition
than building an Access application. Since Access gives you data-centric
controls, forms, reports, and table and query designers, doing the same job
in VB will take you much longer.

d) Since Access and VB are different beasts, used for different purposes, I
don't have links that do exactly what you ask. But here's some that will
give you info on VB:
http://www.mvps.org/vb/index2.html?samples.htm
http://www.mvps.org/vbnet/
http://www.xbeat.net/vbspeed/