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

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions. This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

A quick little app for querying an OLEDB / ODBC database

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.