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

This is a Password Program. does what the Windows 98/95 Password screen does. But the program cover's the whole screen. It shows how to use Database... And find the computer's Username...

This code will blaze through creating even the longest SQL statements(Jet supports up to 64K). This is an updated version of the SQLHelper post I made about six or so months ago, with various optimizations made since then. I have found it to be very useful, hopefully you can too! All code was written by me and is free for all purposes with the exception of cStringBuilder.cls, which is from vbaccelerator.com.

A vb test application which opens queries from access instead of tables for a datareport.I could not individually open selected records so i made this instead.

to easyly find edit and store unlimited phone numbers

Rick's codebank is a simple application which, I believe, would be a good learning tool for beginners. When I was first starting out with VB it was nearly impossible to find a complete working project to learn from. Books and manuals talk all around a subject but never really show you how to do anything practical. They give you a few snippets of code, but never a project complete enough to give you the big picture.

This source code permits to connect to a DSN ODBC connection on a remote computer running dbTCP. THis can be very useful if ODBC licences are very expensive (I had the case).

This is an Access mdb (in Access 2000 format) that searches a directory path for all mdbs with linked tables. There is a two-step process: 1) After selecting the search path, the code searches through all subdirectories building a collection of found mdbs. 2) The collection of found files is opened and each table in the mdb's TableDef collection (yes, this uses DAO, not ADO) is checked for the Connect property. If a value is found, it is added to the list box. In the event there is an error (the mdb cannot be opened, the version is incompatible, etc), the error is noted and the file can be checked later.

this code is made for experimental purpose only. this program recovers the database password created in MS-ACCESS 97. THIS program is created for learning purpose only.

Any true application uses a database, however after deployment, some times you add or modify some fields, and it becomes tiring to adjust the changes manually at clients sites. this is a stripped down version of the application ( there may be some errors due to the stripping down of unneeded funstions ) . Enjoy it without reservations. Vote if you feel like this is something beneficial for you.

shows how to filter a datagrid by selecting option buttons. useful to search multiple entries with a criteria. here i have shown how to filter payments by Due, by Paid, by student name etc... Hope u find it useful.pls vote.

shows how to send datagrid data to report thru a recordset also how to autobind recordset fields to report. This is my first submission. hope u guys will like it. i really like to hear any comments.

a Crystal Report TTX example Shows how to create a report using TTX files, that is you dont need to specify a fixed database for your report. It'll be based on a simple TTX file. Using this you can pass an ADO recordset to the report at runtime. This method solves great deal of problems for many crystal programmers who will benefit from the simplicity of intergrating their report with VB. The report will execute even if the database location changes or renamed. Only you hav to do is change the connection from VB. [supports versions 8 & above.] Read the step by step tutorial and the official crystal guide to TTX available at http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp if you like it,dont hesitate to vote :)

This tutorial is written so that even the beginner will have no problem. It is designed for the absolute beginner. It utilizes the AdoDC and the DataGrid controls. The tutorial is a step by step program to create a simple "Contacts" database with Name, Address, Email and Phone #. This is a VERY easy to follow tutorial with the sample project.

I've seen lots of submission here dealing with databases on SQL. So I decided to create a crash course on SQL to explain what those SQL syntax mean. This is useful for beginners out there as well as for advance users who miss somthing in SQL. All SQL commands used in here are well explained...Have a nice day !

This is for all database lovers out there. Teaches you advanced knowledge in DBMS using ADO.All beginners must download first my "Crash Course in SQL" to give you ideas of some commands used in this tutorial before downloading this.For intermediate and advanced users, prepare a cup of coffee or milk co'z this tutorial takes an hour to read....Most importanly "Learn while you Read".Everything is well explained. Have a nice day ! Comments are welcomed !

A simple PIN Generator with access database. Try it!!!!

To show you how to talk to MySQL easily. This makes it too easy.

This simple demo demonstrates the speed of GetRows Method Compared to movenext method of ADO. The first and second listboxes show this while the third demonstates yet another example and use of getrows, joining arrays of data from a recordset. You can compare the speed of this method too.

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 tutorial aims to provide an intermediate Visual Basic 6 user with the basic skills required to retrieve and manipulate data from many commercial databases and any ODBC compliant database using the Active Data Objects technology. It includes a sample project and a full tutorial in Word format. The html version can be seen at http://users.tpg.com.au/jaqmar/adotutorial.htm.