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

Irshad Alam wrote:
> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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/

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Irshad Alam" <(E-Mail Removed)> wrote in message
news:6E30AE82-9E61-4788-8E7A-(E-Mail Removed)...
> 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