Sample Code 
-
It is always troublesome to add a DSN entry whenever the program has to be run on another computer. This source code tells how to prevent this problem.. 
-
This code will save the treeview node when click add region/branch in Access format. When run the program the treeview will load the Access file..
-
Simple snippet of code to compact and repair any MS Access database..
-
ADO class containing useful functions - counting records, creating database from scratch, openning/closing database, filling listbox/combo box with an sql statements, manipulating records....and much more..
-
Too all you newbies out there, This is something I wrote for a friend of mine, teaching how to use the basic extraction-from-db utilities. It shows how you can link an Access database using the ADODC Component. It includes thorough explanations and examples.
It really is teaching the basics of ADODC components - nothing fancy - I just remembered my own time as a beginner, trying to search for new ways to learn. I hope it will help you :)
~moo.
-
This code shows you how to create a table and it's indexes in a database at run time..
-
These groups of Procedures will allow you to Open Databases, Run SQL Statements, as Well as Execute Stored Procedures without hassle....
-
How to install ODBC connections remotely using the Registry API, connect to a network machine, and install users System DSN's without having to travel around sites..
-
This is a conceptual idea of how I start to do database programming. In this article, I had highlighted a few points that become vital to understand for any new comers to do database programming..
-
Print all the Table names and their respective Column names in whatever database you choose.
-
This project will show you how to create reports in VB using the data report utility, this utility is very easy to use and it only takes minutes to create flexible reports using this utility..
-
A quick and easy way to pass a Recordset to the ListView Control and format control's content using Data-Aware Classes..
-
How to reuse ADO recordsets without destroying them first.
-
VB myth #2: Use MoveFirst before looping through ADO/DAO recordsets .
-
How to compact and repair databases via ADO's JRO.
-
Manipulate Lotus Notes services and databases.
-
How to compact and repair Access databases using DAO.
-
How to add and remove records using the Data Control.
-
How to validate your text box, and only accept numbers in a text field.
-
Important differences between Access, VB and SQL Server wildcard characters.
-
Load data between two databases online.
-
Examples of a connectionless recordset.
-
A neat trick to allow you to use numeric keys in the ListView control.
-
Entering parameters into a DAO parameter query.
-
How to build a data-shaped SQL clause for VB.
-
How to accurately read text files into ADO recordsets.
-
How to prevent phantom apps when using VB 6.0's DataReport.
-
Use VB's ADOX to determine if internal database objects exist.
-
How to refer to a DE Command's recordset in VB 6.0.
-
Automatically generate a HTML form from an SQL query.
-
An example of a bound form using the ADO control.
-
How to count the number of records in the Data Control.