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

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or daveismith@hotmail.com

Using ADO: This is a demonstration of how one can take selected items at runtime from a user, create a parameter query using the selected items and then run the parameter query.

This is a new version. New additions include 2 types of code, one project-based the other snippets and functions. More settings added, including large or small toolbar icons, dock list on left or right, activate and maintain transparency. Checks to see if the program has run before, and if not, it sets up the default Registry settings, and if so, it just runs the program. Now asks for database location based with the default bein App.Path\codelib.mdb. I am starting to get more reuseable code. Combining forms and functions based on the type of code and user action. I will eventually combine the ViewCode and Add/Edit code forms for both types. It will require a full rewrite of most of the functions and redesign of the forms. Also in the works is the program's compiled HTML help file. I have almost completed the commenting of the Sub/Function purposes. Please bear with me as the commenting of the code is not the highest priority, getting a working, useable application is the priority. I have included two (2) versions of the actual database: codelib.mdb-Access 2000, and codelib-97.mdb-Access 97. Please leave me comments and questions on the code itself. Votes are appreciated, but not needed. I would rather have the comments.

Class that allows to create or edit connection strings using datalink of ADO. Suggestions and commentaries are welcome. Vote me!!

For beginner database programmers.

Second code for managing database series. Querying with SQL and basic dictionary application. Enjoy it.

This code will save and retrieve bitmap graphic files from an OLE Object field inan Access 97 database. The same principle applies to earlier versions of Access/VB, but I haven't tested them. You'll need to use the appropriate DAO library. Let me know if you find a way to save other graphic formats.

Exports an ADO recordset to Microsoft Excel.

This is simple database program to demonstrate the use of ADO and OOP. The program includes functionality to navigate through the records, add, save, delete and find. All functionality are encapsulated in a class. The program contains very minimal error trapping, error handling and input validation. No data bound controls are used in this program. The program shows how to use ADO, Classes, Basic Module, Simulated inheritance and more. I intend to expand this further to include an error trapping and validation class. Other functionality will be included soon. In fact, this is a subset of a larger database program for a retail store.

Allows you to automatically generate column headers and load all the records from a table or SQL statement into a listview.

This Dll is just an expansion upon the previous submission to create .xls without having Excel on the machine. It allows an ADO recordset to be turned into a spreadsheet, with some formatting controls (borders and allingment). It also allows floating point values to be added, the conversion routine was nicked from PSC, and is left pretty much untouched from the submission found here.

As a lot of other people's reasons for posting source I post this because I couldn't find any help with the MS Data Environment. So after playing around with it I finally got it to do what I wanted it to. This Example is composed of basic ways to manipulate the Data environment. Add, Edit, Delete, Search, and pull report information. Use of ADO Transactions is also covered. Hope you enjoy it and learn something. The example uses the basic contact database concept. Please vote if this code is useful.

This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

This is an excellent database program the screen shot speaks for itself has a lot off features. Basicly for storing and keeping track of employees. "PLEASE RATE IT IF YOU LIKE IT" it also has a custom CD Player built in. I will be uploading version 2.0 in 1 week so keep an eye out for it cause if you like this you'll love version 2.0. Still a littly buggy but it's still in its beta stage. Thanks PSC

I have worked out all the bugs in this realse, I changed the UI a little but it's still the great looking employee database. PLEASE RATE IT IF YOU LIKE IT . Any comments are welcome. The User Name and Password is "admin"

This tutorial will give you a crash cource in working with Interbase (A free, open source databese from Borland) and ADO. It will show you where to get the database engine and teach you some simple basics.

This code snippet will show you how you can convert an ADO recordset to a delimited text file in just a couple lines of code using the ADO GetString Method. You can easily export a recordset to a csv file using this method.

Create Shape Statement For Master/Detail Form In Visual Basic.I Made This "Generator" Because I Couldn't Remember The SHAPE Statement And Now I Publish It For All Developers Who Cannot Remember It And It Is A Good Example Of ADOX And ADO.The New Version Is With Full Test Of SHAPE Statement.

PlanetSource code is a life for VB programmers. I have learned many thing from this website so I felt I will give this code to all the programmers who are willing to learn the database concepts. I tried for this kind of code but all in vain. Dont worry. This is the best and the ultimate code for all the Database programmers who have been waiting for ages. The whole world is looking for a control of this sort. I as a enterprise solution provider found it very difficult to debug the recordset and find the exact match in the recordset by pressing F8 .. F8 .. F8. Dont you think doing this way wastes your time and money... The main purpose of this code is to print the contents of the recordset of ADO,DAO,RDO. Within a fly we can see the contents of the recordset. This will save a lot of time. The main purpose of this code is to pin point the exact location of the data that we need. We use filters to check the data and reduce the recordset to find the exact match. But this control by clicking on the tab sort the contents of the recordset and display to us. You can change the order of the recordset fields by dragging.