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

On a machine where the Adobe PDFWriter is installed, the current printer is swapped out with the PDFWriter and the PDF file is created. The original printer is then restored.

This is a simple usage of database as long as VB and MS Access are concerned. But you can certainly use this on your literature class. Zip file includes a database containing more than 200 biographies of classical authors.

This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.

This is a Class that encapsulates the ADO object Model and make life a little easier for Developers. I have included the SmartSQL class for which all credit must go to FreeVBCode.com The ADO class simplifies DataShaping, SQL, Connection Management, XML RecordSets and many, MANY more

For conversion of MS Access Databases between JET 3.X and JET 4.X (MS Access 97 and MS Access 2000) using DAO 3.6. This is my first contribution after years of visiting PSC. Not detail commented. (Please see the ChangeMDBVersion.exe.txt for more information.)

Thanks to Collin McAllister for the 7/13/1999 submission this is based on!! A visual adhoc query form that allows multiple criteria selections and simple joins. A simple (limited) somewhat user friendly way to create simple queries.

Address DataBase Shows VB and ADO

This was a piece of software i did for my HSC major assesment, 93% cheerin! Anyway, i have put a fair bit of work into it, it still has bugs, coz i only finished it the other day i haven't had a chance to fully de-bug it. There are also some changes I would like to make in the near future, but it is basically finish, so please enjoy, let me know what u think, and PLEASE vote high, i would love to win this months comp :-) The Admin Password and Teacher password are both "Gilroy"

Add Your data to Access Database/Edit/Delete/Add to the main DB.

Updated: Dec 02 2001, Ver 2.5 updates are functionality to associate MS Access (.mdb) databases with Database viewer/editor, and to Maximaze the application. View/Edit data on databases that can be MS SQL-Server local/lan or remote on internet, or a MS Access database. Get Data by clicking databases/tables/columns/views/stored procedures or perform custom SQL queries. It shows ADO Programming and Some API. In this version I have fixed some bugs from previous releases and improved the functionality. Now you can view the "source" of all stored procedures and views in SQL-Server. Thanks to all who came with feedback/suggestions in previous versions of this application. The project is made with VB 6.0 Service Pack 5 and I used MDAC 2.5. Please help me grow as a programmer and come with feedback/suggestions.

This small application will allow users to search for contacts by name using a ComboBox. This project shows use of ADO, Search Methods, and Modular programming.

Copy the table structures and records from one database to another. In my case, I use this code to copy from an ODBC SQL Server database to a local Access to allow users access to a copy of the data when they are not connected to the network.

This COM app was developed as a drop-in module to access databases across the corporate network in a variety of applications. I'm posting it here to get feedback - am i doing the right thing, could i change it in any way? make it better? all comments (constructive!!) appreciated!

This code pastes into a Module that Create (if not exists) a MDB to record the errors that occur in your application.

All fields in the selected table are processed and the AllowZeroLength property of the fields are set to either True or False, depending on the Status given as the finaal parameter The function returns a boolean value that can be used by the user to determin other operations.

This is an ADO DB tutorial for programmers who know nothing about ADO. It is a good template to following when making your own project. I hope that it helps.

This VB6 project demonstrates how to edit an ADO multiuser recordset using databound controls. It is based on the 'single-record form' created by the VB wizard, but adds: * Enhanced error handling * Improved user interface The demo allows several instances of the form to be opened, for a 'pretend' multiuser network.

DAO based database program with many features in it, I also noticed after searching around I seen no databases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank... Also added the ability to change the color of almost virtually everything you can see. This is my first database I made or even attempted so don't expect much from this but I think for a first attempt this came out da!mn good... I know my error handling lacks a lot and I think I will be implementing the ability to email from this program, search may be implemented but I never had a use for a search option in all databases I used so thats a maybe... Also I plan on adding a user login feature, I tried to comment on as much as possible this is basically for those looking to break into databases since I think I successfully created a pretty good first database. **Extra Cool features** Double clicking on the email text box will open up your email application and fill in the To: field with the contacts email address, double click any phone area option to call up a form in which you can type in the contacts number and call them (example taken from the sample that comes with vb6, i just thought it would make an excellent option... Also your pc must be connected to the same line as your phone line in order to work) and double clicking on the Homepage Title or Homepage URL will open your browser and take you to the contacts homepage...I also included a timer feature so you can specify any hour or minute you wish and set the alarm then it will display a message box at the specified time reminding you to complete your task...

This Program generates ADO code and SQL Statements without the use of an ADO Data Control. It is available as a stand alone executable or as a VB-6.0 AddIn.

This code is used to search for clients in an access 2000 database using ADO and a parameter query. In our database we have roughly 20000 records to search and it still finds them very quickly.