Visual Basic and ADO Tutorial (VB6)
This tutorial presents three small sample applications using ADO. All three applications use a local MS Access database.
The first sample application introduces the ADO Data Control (ADODC) which demonstrates a "quick and dirty" way to connect to a remote database. The second and third applications use ADO code: the second allows navigation and searching of a database table; the third allows navigation and updating on a database table. All three connect to an ODBC Data Source, which must be set up through the Windows Control Panel. How to do this is described below.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am working on a migration project to convert a Visual Basic 6 system to a new platform. To make life easier for the programmers I would like to develop some plug-ins for the Microsoft Visual Basic 6 IDE.
But until now I’ve found only information about using vb6 to write plug-ins for other programs. Does anybody have some information about how to create a plug-in for the Microsoft Visual Basic 6 IDE (SP6)?
I have written a dll in vb6 which works fine on my machine however when I put it on another machine when the component is called in the asp script I get this
along the top of ie or netscape - I have tried installing the vb6 runtime files but it still doesn't work
However if I install visual basic onto the machine in question and then compile the dll onto it it does work. this is obviously going to be totally impractical - what do I need to do?
are the vb6 runtime files not enough? do I need to create a setup package of some kind?
Microsoft Access may be the most powerful programming tool available for Visual Basic. While nearly everything Access does can be accomplished with Visual Basic code (there are exceptions), Access makes most design tasks so much simpler that I consider having a copy of Access as much a necessity for database development as a keyboard.
ActiveX Data Objects (ADO) enable you to manipulate the structure of your database and the data it contains from Visual Basic. Many ADO objects correspond to objects that you see in your database. Learn how to set properties for ADO objects.
As you work with Access, there may be times when you can't write a macro that's capable of performing the operations you need. In such cases, you can turn to Visual Basic for Applications, a programming language that's built into Access. In short, using Visual Basic for Applications, you specify a list of instructions you want Access to perform.
By the time you finish this chapter, you will understand the following key concepts: what Visual Basic for Applications is, how Access uses procedures, functions, and subroutines, the parts of a Visual Basic for Applications program, how to use statements, variables, operators, and functions within your program, how to address database objects in Visual Basic for Applications, how to use the VBA Editor, how to develop a Visual Basic for Applications procedure, how to test your procedures and how to use a procedure from an Access form.
As I'm designing my database, it has come to my attention that I will need to do some programming in Visual Basic to achieve some of the functionality I want. I'm proficient with java, so I already understand how to program.
I'm just having a tough time identifying a tutorial that is neither designed for first time programmers nor for people already well versed in visual basic.Do you have any recommended sites?
I want to edit a .bas file, but I don't have VB6 or any visual basic editor. I read it somewhere that I could import it to notebad etc but I cannot change the code.
I just have to make a slight modification by putting a different path of the database.
When I upgrading visual basic 6.0 code to VB2008 by the tool of visual studio%uFF08Tool->upgrade visual basic 6 code%uFF09, an error arose.The following is the error message:
"File I/O error:the given path's format is not support. Delete _vbsnipup directory and try again."
Can visual basic 2010 open visual basic 6.0 files? Is it possible?
How to use Visual Basic for Applications (VBA) with MS Office tools, including VBA for MS Excel, VBA for MS Word, VBA for MS Access, and a general overview of Microsoft Visual Basic for Applications.