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

This Module allows easy connection to SQL Server 2000, ODBC, Access 97 and Access 2000 databases. The code is well commented, so may also help a beginner to get started with DB programming. If you use it, please rate it, and i look forward to any feedback you might have.

A Quick & Easy Search routine for ListViews AND Recordsets -- hand in hand. I find that a very nice pair-up in interface and behind the scenes action is the DAO set in conjunction with ListViews. To some this may already be apparent, to others perhaps not. Copy this code in, using the correct DAO refs and the correct ListView, pass the three parameters in, and it should work like a charm. Don't forget to vote for this code. Updated / Patched - 11/4/01 Check out this screenshot ->

One of the most wanted feature from users point of view in MS SQL Server is capability to generate INSERT scripts for MS SQL Server data. But call it Microsoft's ignorance, this feature not supplied since quite long. And even worse, there is no public domain application to do that. This feature is usually desperately required in situation like sending test data to somebody or supply sample data. So I decided to write my own. It's still isn't the perfect and can't handle all of the possibilities but it could be your best bet with supplied source code! This application is right now in state of easy installation but no on-line help is available. You may freely contact me for assistance however.

This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

The prodram look just like Access, so don't be mistaken. IF you won to learn how to work with databases- the answer is Quarantine DB. The program uses ADO and DAO. With QuarantineDB you can work with, create, delete, rename tables and queries, add, delete, update records. You'll learn how to work with MDI form. Just try it and don't forget to VOTE FOR ME. e-mail : [email protected]

This project is based on CODE_UPLOAD1185011192000.zip. I added a Class structure to the Server and added some other checks. This upload is a Multi-User Server/Client project. The Server has also a very reduced sort of database behind. Every user can create one or more buffers which should act as a one-dimensional recordset. The buffers are being filled by a simple Selection statement. The purpose of this work is to figure out if a simple database server could be built up in this way or if you have to do it totally different. I'm actually looking for some critics to understand why this is a good way or why not. So please give me comments. No votes needed.

This program is designed to teach the user how to load data into a FlexGrid from an Access database and then manipulate the FlexGrid to perform typical database actions such as Add, Edit, Sort, and Delete. The database manipulations are executed with ADO methods

Helps to maintain credit customers, with the details of bills and outstanding balance, etc. Useful for small companies, total solution. No need to purchase big software which has got too much unwanted functions for which you don't need to pay for. The code has got very useful stuff like managing ADO DB, creating reports, etc... hope you like the code and most of all the application. Most of the reported bugs are fixed (which were a few ui bugs). Check out now the update.

This OCX will helps you to retrieve all types of images supported by the Visual Basic Picture box in one line of code. It save it to- and read it from an access database. It support Ado and DAO. You can browse for photo images on your harddisk with the filebrowser included into the OCX. This browser also remember the last directory. This code is well commented. Just click on the ocx, drag it on a form and start programming. This code has not been tested on SQL server jet. I've included a sample application to show you how it works. I hope it will be an attribute to your programming needs. For any comment mail me at [email protected] Have Fun. Rodney Godfried

This code will allow you to populate DBGrids and other bound data controls using a Data Control, SQL, and an ODBC DataBase.

The project has two forms. Both displays charts using mschart control for a data from access table. One form displays a chart(2D BAR) for the first record of the table. The second form displays a chart(2D BAR) for a set of records. 1.Both the charts displays legends. 2.Both the charts displays titles for X and Y axis. 3.Both the charts accepts a title to the chart at the desired location. 4.Both the charts displays data values at the desired location above the data points of each item. 5.Above all, the second chart(in the second form)displays bars in the charts dynamically as and when records are entered. i.e., if there are five records, five sets of data series will be automatically displayed. 6. Column labels and row labels are named in the code itself. 7. Filling colors to each data series is mentioned in the code. To summarize, a customized graphical representation of a set of data from an access table can be created by any user.

This is a veeeery simple code to make one autocomplete textbox that gets the first letters you typed and searches for the most similar word from a table and then completes the rest. No API Calls, No Classes, Only few lines of code in 2 events...Simply save it as a module (.bas) and add it to your project

This is an example of a DAO DATABASE CONNECTION PROGRAM Este es un ejemplo de un PROGRAMA DE CONECTIVIDAD A UN BASE DE DATOS POR DAO. This program contains an english part, for those that speak english. Este programa contiene un parte en español, para aquellos que hablan español.

This program convert Access Database to the MySQL database. It has many functions like Copy Full Database, Create Only Structure, Create And Copy Database, Create Table Structure, Create And Coppy Table, Coppy Only Row etc ... I made some examples with it and although i used an access db with 100 000 records it did not gives any error.

This is the database editor version 2. I did not submit the first version. However, I made changes and enhancements to improve the program. It only works with MS Access type databases. A person does not need access installed on their computers for it to work either. You can create new databases, open existing databases, compact a database, add new tables and change the database structure. If there are any suggestions for improvement, questions how to use it, to give feedback, or even if there are any hidden bugs, please do not hesitate to email me at [email protected]

Digital Statistics Calculator saves all entered data to a DAO database and can send it to Excel for graphing. The lab where I work wanted this to avoid doing double data entry.

This code will allow you to make a DAO database using code instead of the Visual Data Manager. This is good if you need to make a program that makes a database from scratch on the user's computer. Has many uses if you are a creative person! Please vote for this code if it helps you in anyway. If there are any questions, just email me. Thanks!

This a example for call one or more store procedures with different input parameters or without parameters.

Want to work with MSACCESS database? This code is for you. You can perform add, update, delete and searching operations on database. Best part is the searching.UPDATED WITH FULL HTML HELP ON 9th Oct. 2002.How to write to registry is also explained with full error handling.Please vote for me....

This sample program is just used to show you how to load the entire Database into a Tree View Control. (*This sample is complete DataEnvironment based.) The Recordset(the Command Object in the Data Environment Designer "Database") can be set by property pages in the designer. But here for the ease to use, I let you browse an Access MDB file. In fact, you can use any type of recordset(Excel, Access, DB, SQL, OBDC...).