Access - Visual Basic 6.0

[tpearo]

I starting to learn Visual Basic 6.0. I am doing this with the hope that it will help me understand and write vb code for some of the functions I would like to use in my Access databases. Is Visual Basic and Access Visual Basic the same?

Can you convert or export out items from Access to a visual basic project?

 

[JerryDennison]

Yes and no. While the two are not exactly the same. They do share common syntax and are very similar. So anything learned in either will help with both. As for "sharing" functions between the two. You can do this to a degree. You can also utilize functions written in VB in Access, just as you can use many of the built-in functions from other applications in Access. This can be done in many ways, either directly through DLL calls or "importing"(after a fashion) the functions, or through OLE automation.

HTH

 

[scking]

I guess the question would be, which Access. Access 97 uses Visual Basic for Applications (VBA) which has Visual Basic at its core. There are differences in functionality between VBA and Visual Basic 6.0 because VB 6.0 is one version up and the controls are different. However, Access 2000 is essentially VB 6.0 (limited). Visual Basic 6.0 has many types of applications that it can build, ActiveX controls, DLLs, etc. while Access 2000 VB is only integral to the database and can not build external applications. However, they are mostly the same.