What is the difference between visual basic to Microsoft access?

Answer 1

n 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