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

I think Flexgrid is Important in any Database Project. I made Readable / Writable Flexgrid for convinience to Add / Edit Data.

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 is a Sales and Inventory created in Visual Basic 5 for the fulfillment of the BSCS course in Asian College of Technology in Cebu City, Philippines. It is originally programmed by Jerson Chy(super programmer) and was re-designed by Ted Antonio(computer hacker). Hope to receive messages on this system..It is complete and very useful and it can even be sold to anyone who wants it...Happy selling this product

This code demonstrates how to use a connectionless recordset.

Example for data validation, database and data manipulation. If you like to see implementation for Search and Filter than take a look at ABCStores_02. Please vote.

This code will import textfiles into a MS Access database using different kind of seperators. A MUST SEE CODE! It works great and can be used for a lot of things!

To remedy difficiencies in ADO, namely single criteria in the .FIND method. We encapsulated an ADODB.Recordset within a vb6 class module, and created four methods (FindFirst, FindLast, FindNext, FindPrevious) which allow for more that one criteria.

Undocumented Trick for calling stored procedures in vb using ADO

Add / Remove User Using Access Database User: ADMIN / Password: admin / Level: Administrator

This program, show many statistic about your Data Base And it convert your data base to HTML and SQL format. Please, Vote for my source code...

This sample project shows how to scan a network for all domains, then list either all servers on the domain or only the SQL servers on the domain. It uses the NetEnumServers API call and a NetEnumDomains function found in the NIMM.bas module which was originally written and posted here by *Patrick Herbst*. The NIMM.bas module has a TON of features for network management. FANTASTIC JOB Patrick! Thanks also goes out to Michael Monaghan for directing me to the posting that LED me to this solution. Even if this sample is the greatest thing since sliced bread to you (doubt it), please do not vote for this module, 99 percent of the REAL CODE was not written by me. I used alot of ideas from alot of authors (including Microsoft's technical articles).

Store Files to Access-DB and restore them from DB to File and more...

Store name and address information with associated call logging. I use it to track calls to job agencies while I'm looking for contracts.

It loads the present records to the inside with a Database in a ListView with ADO and through SQL it is possible to load the records, it includes also the ordering of the columns in ascending way or descending with the icon that it indicates the type of ordering. Finally the present records in the ListVIew are possible to print through 2 selections all or the records select to you through checkbox. Code is full commented! PLeaSe VoTe FoR Me!!!

You can connect three databases at one point of time through this application i.e. SQL Server, MySQL and Ms Access. Simultaneously, you can get the references of all tables and connect with DSN too. Adding to this, there is one big utility that changes unformatted SQL queries in two formats [For VB Formatting and For SQL Formatting]. Much more trendy feature that are unanimously claimed by anyone and don’t forget to vote for me.

This utility allows you to easily update the structure of one .mdb file from another. It analyzes the source and creates the changes to the destination. It is a good tool for quick updates to multiple files. Please keep in mind that this was kinda 'thrown' together to serve my own purposes and is by no means a finished work.. it has helped me and I thought it might help someone else... :-)

SQL Server Viewer-Updated: Connect to SQL Server, Select Database, Tables, Views, Procedures, Parameters, Datatypes, execute queries, save queries, open queries. Very useful for working on MSDE Servers! Feel Free To Contact Me With Questions/Comments.

The purpose of the following code is to demonstrate how you can load a datagrid with data from a text file.

These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.

This code takes a user specified Access Database (I used Access 2000) and prints the database structure to a printer or to an HTML file. Currently working on adding Queries, etc. to the mix as well (Version 2.0!!) if i get any feedback.