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

Good for beginners who want to learn database. I include simple code in searching,add,edit,delete,print in the system. It has good GUI.JUST TRY!!!

READ THIS° : Do you have so many Source Codes and don't know how to arrange them?. Well, here is the answer to all your problems. The Ultimate Source Code Storage Database utility has come atlast. The program contains whole new features where users can EASILY STORE: CODE NAMES, AUTHOR NAMES, DESRIPTION( Read Me's), PLATFORM, PROJECT LOCATIONS, ZIP FILE LOCATIONS (Backup Locations), RATINGS, DOWNLOAD LOCATIONS, DOWNLOAD DATES, CATEGORIES,COMMENTS and whole lot more. The Code contains BUILT IN advanced SEARCH PROGRAM where users can easily search their code in the Database. Have a look at SCREENSHOT. Users don't have to worry about Zip files that come in unique names, just mention the Zip Location of the code in this program and program will do the rest- by storing the Zip file location in the database. You can EASILY OPEN- Projects, Zip Files, and Screenshots. In the same way you can store author name, readme's, Voting locations, download dates, comments, personal ratings and lotZ more. This program uses a eye catching Visual Styles with Windows Xp like interface. If you want to Print- then this programs ADVANCED PRINT facilty is just for you. This code is optimised for Planet source code users but you can twist it the way you want. This code also contains Easy to Use ADD ENTRY FORM where users can easily add their code and their details to the DATABASE. You will never know How this utility may come in handy for you, until you download the Code. Perviously i was using this utility for my personal use and this time its for you with a bunch of New ADVANCED FEATURES. Please DON'T FORGET TO VOTE FOR ME. Add this code to the Database first.°!!!°

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.