Basic Difference between Visual Basic 6 and Microsoft Access VBA

[Guest]

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

 

[Rick Brandt]

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

The object model for forms and reports is where the majority of the differences
lie. The actual "code base" is the same.

 

[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/