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

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.

Address Book XP is a contact management and address book organiser. This program currently supports user logins, reminders and some advanced uses of Access XP and 2000. This code was designed for Windows XP with Office XP or 2000. It hasn't been tested on other machines yet but hopefully you guys and girls will be able to help with that. There is a lot of work that needs to be done with this code such as a suitable search engine and some user managemet. If you feel you can add to my program, please be my guest, as long as you mention my name somewhere in there. Comments will be greatly appreciated. Tom

Ever be in the middle of coding and forget the field names in your database? Well this little tool is for you. Open an Access Database and it will display all of your fields as well as the description and ALL of the properties for each field. You can Drag field names right from the list into your code. Never have to memorize (or type) those long field names again. Click the stay in front button and the application will stay on top, click it again and it will fall behind other windows when it loses focus. You can also search for a field name. If enough people like this I will convert it from DAO to ADO. Please leave comments. :) Sorry for the missing .bas file. Its there now. *** 3/20/02 - Added recent file list *** 3/21/02 - Added datasheet option which allows you to open the selected table and add, delete, modify, and view data from the selected table. You can use SQL to filter the datasheet and it also has the "Stay on Top" feature. You can open as many DataSheets as you want. ADO Version coming soon!

This video rental program with printing capabilities and Flexgrid to Excel feature is usefull for stand-alone PC. This is my first database programming experience in visual basic 6.0 Service Pack 5. So please bear with my coding techniques. Here you will learn how to use ADO and DAO to access a Password Protected database and how to use SQL techniques. Some of the snippets were also taken from PSC submissions. If you like my program please vote for it. I would appreciate any suggestions or comments. However i may not be able to answer emails since i'm busy most of the time. Thnx!