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

Load your categorys in a treeview, create new entries under your personal categorys. Three (!) completely different kinds of searching will help you finding any entrie you are looking for. You can create new categorys, delete or modify them. Learn how to create a better database for contacts, source code or whatever. The Treeview is resizeable ! easy by draging it to the left or right! The sample application is 90% done, fully functionally and kept without a personal note for a simple demo. (means no pics and icons you are deleting anyway ) You can easily change everything for your own needs. The database is MS Access 97 Format. (You can upgrade to MS Access 2000 without changing any code. )

This code enable you fill a DataReport with the information contained in a Recordset. In this example, I have a connection with a database and I fill the Recordset with a SQL sentence.

This code will allow you to populate a listbox control using an ADO recordset. I am using the standard VB ListBox Intrinsic control. Everything is done through code.

This document explains how you can write Oracle stored procedures, that will return ADO recordsets to your VB or ASP application.

This code creates and maintains a database of multiple users that may use your program. This supports user flags that YOU specify and define as well as a checkpoint system that YOU build! Documentation and sample projects included.

This shows how to two things, first how to pass variables to a stored procedure on a SQL server, second it shows how to handle multiple recordsets being returned from the stored procedure. This allows for a greater speed then trying to pass the entire SQL query to the server especially when you have several. Please Vote if you like it! :)

Connect to any ODBC compliant db using RDO. by the way MySQL, Oracle, FoxPro, Excel, Access, Sybase are all ODBC compatible. Use this code to connect to Unix databases, Linux databases, etc. Very simple (easy to follow) code. If you would like to see the same in ADO, or want me to add DB creation/editing capabilities let me know. Currently you can just add, update and delete records as well as run queries. Please Vote, I stayed up late working on this. Comments positive and negative welcome.

This source code was originally to predict lightning strikes. This source code is run in MATLAB and can be modified for different no of inputs. Meaning, this source code can be used for any kind of prediction!

this is a code to specifiy .MDB from your app not from properties it is just for a beginner...

This code will take data from the Northwind database and write it to an Excel spreadsheet. Code can be modified to do more complex reports, but the basics are included here.

This is the better way to find out whether your particular table, any table, exists in your database. Sequential is NOT the way. Check this out and let me know if you have any questions. Please give me a vote if you like this code :)

The Grading System helps maintain and organize a secure and dynamic database in an educational institution. This program was mainly a project for my VB class. I'd like anyone to give their opinions/ideas/advice on this program.

This small program is very usefull when you want to compare destination mdb file from your development mdb. It is not only compare the database (tables, indexes and queries) schema but also Fix It !, this prog use temporary mdb to hold the schema so you just bring this prog and schema file and compare it at your customer. if you like it please give me a credit!

Application to access Adaptive Server Anywhere databases. Uses CMAX OCX (http://www.compiled.org/files/115/259/cmax20.ocx). Uses RDO for data access. All other components are standard VB components. Help File not included because of licensing restrictions. Sub Main is in sqltool.bas. SQLAny.bas has data logic in it, and could be modified for other databases.

This program demonstrates how to access, modify, and save information from a Microsoft Access Database file, using a GUI. Users can add view information with a listbox, open a webbrowser to a contact's url, even send them an email using the default email client on their machine.

This is a Visual Basic Code Guide to keep track of all your Basic Code.. This is fra from Complete, so Suggest any thing yuo would like to be seen on it. And yes I know there are plenty of these on PSC.I wrote this foir my self and for others to learn not to just get votes.

This project demonstrates some code concepts such as use of classes, functions, passing variables, and registry control for setting SYSTEM DSN's under ODBC.

If you do any work with Access, you'll love this. It adds a sliding TreeView to the side of a form in MS Access allowing you to navigate through data

This is the code from a class module for exporting from any Jet database to any ISAM format out there. I think it neatly encapsulates the process, and uses properties and methods to make the process as easy as possible.

Simple, but effective. If you use MS Access for Client/Server apps, you'll never need to write another piece of code to display your reports, just add this form to your DB and it'' do the rest. Double click to open a report normally, or send it to Word/Excel or HTML format.