Results for "Category: Databases/ Data Access/ DAO/ ADO"

This code creates a Microsoft Access MDB dynamically.

It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.

This is to show new developers to Databases how to develop applications with VB and ADO. It is very well formated, step by step. And if you like it Please vote!

This is to show developers (mostly new ones) how to use XML / ADO technologies from within VB. I got the XML source code from a project on this site and put it to use! I hope that this will help someone out!

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

This database comparison tool can compare 2 databases for differences. It can give you missing Tables, a script to create it... Check 2 tables for missing cols... Right now this works with only MS Access Databases... planning to include SQL Server and Oracle too.... This uses ADO objects... so mdac 2.5 is required on your machine. This is available in Microsoft's Website.

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

This code demonstrate how to connect to database (Patients97) using ADO code alone. I also demonstrate using the MonthView control and MSHFlexgrid control. The database called Patients97 contains customer details like name , address, customer number etc and appointment date and time. On the form, I have an MSHFlexgrid control, a MonthView control and a command button(cmdViewAppt). Clicking the command button connects to the database using ADO code and the details are displayed on the MSHFlexgrid control. You can display appointments for a particular date by clicking on a date on the MonthView control (MonthView1_DateClick event) and the result is displayed on the MSHFlexgrid control. I have not figured out how to create a report yet. What I'll like to do is to be able to pull the information on the MSHFlexgrid control and display it as a report which can be viewed and printed.Preferably I'll like to use the data report designer but I won't mind using excel or word or is there a way to use DataEnvironment designer? Please e-mail me any improvements or additions at [email protected].

I got the the layout and design of the program from CONTACTS 2000 made by [email protected]. BUT the code underneath is radically different! This program MANAGES AN ACCESS2000 DATABASE with SQL and query's with Recordsets. The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network. It also queies a recordset and spits the results to the NEW DATA REPORT in VB6. I worked hard on this one! enjoy. READ README.doc for info on running. e-mail me at [email protected] for questions. PS. THANKS MICROSOFT SUPPORT (GENE MOODY)!

This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks: Save the data stored in a SQL Server Image column to a file on the hard disk. Move the contents of a .gif file to an Image column in a SQL Server table. ** Article ID: Q258038 - I take no credit for the code, I simply created a project from the example in the article **

This a Search program that searches for a 'specific record in a database. This is a kind of DISTINCT search. Where u just have to enter the first letter of the data u want and it gives u an output in the grid.

Lists records into a listview control using basic SQL Statements.

The purpose of this example is to connect/display database records (using ADO) with a simple listbox. This is a work around to using bound controls. You will find your apps will run faster.

The purpose of this app is to show some basic operations on databases using DAO 3.51 . Very good for begginers.

Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.

This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...

A report wizard which allows users to create their own simple reports and outputs them to a word doc. Includes sorting and criteria. I have modified this from Oracle to Access for demo purposes. I am also still working on it so any positive feedback would be appreciated. There are a few more things I would like to do like sort the Criteria operators according to datatype with, add totals. Feel free to use and modify. If you come up with anything good send it on!! This is the first app i have uploaded so I hope it works!!!!! Please read the attached readme file as there is a few things to do before the app works. i.e. add a query to a database.

Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.

DataAccessDLL's SUCCESSOR - as a control. GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the CTL with an 'INSTRUCTIONS' function.