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

Hello guys!!! This submission is a complete OLE DB Provider Guide. Many beginner database programmers out there don't know how to connect there application in defferent database, in lan and even in a remote. This guide will help you a lot coz it gives all example on how to connect to a database using OLE DB Provider. Pls. Pls. Pls. Don't forget to vote this appliction.

I created this for work to maintain a list of databases that we have for different product lines. It uses the Access 10 Object Library to perform this functionality "behind the scenes", so to speak. By doing it this way, you should notice a vast performance increase. NOTE: If you do not have Access 2002, this will not work for you unless you have msacc.olb registered on your system, but there are other options that work in much the same way.

[ADODC IS E V I L!] Have you reached a stage when you realize that the standard ADO Data Control Shipped with VB is not enough for you?? Ever Wondered How You Can Connect To A Database with code? How You Can Read, Write, Delete, Change data in Tables ? Well, Here's a small Application which uses ADO Code to manipulate data in a table. I've also included code to Enable or Disable the Command Buttons in the Window based on the context (For exampling disabling First & Previous buttons when you are in the first record...).

IT IS USEFUL FOR SMALL COMPANY, & ALSO CALCULATE THE EMI, PF..

This is a Registration System, it has two application, the client and server. It uses ADO connection and Winsock. You can add, edit, delete, view a record. The server is password protected. I also included a chat. Other stuff are Minimize in System Tray, Compress Database, Install on Startup, also every action made by Client is log in the Server. The Help file is included. Please vote first before downloading this code. Thanks to Chris Hatton for the Ado.

I share this program for others (specially newbies) to have idea on how making software. In this submission you will learn how to connect in MS Access Database using ADO and ODBC, Update/Save/Delete/Search record, open an excel file, computation, formatting, etc. just download it and have fun. Pls. vote and let me know your opinion. I highly appreciate your feedback. Thanks! :D

It allows the end users to encode the necessary transactions for the products delivered by the supplier and the products delivered to the customer. it has necessary maintenance for the customer, products, suppliers and users for record keeping (with add, edit, delete, save, find and cancel button).Counts the remaining item and prompt messages when in reaches the critical level of specific product. It has report sample as well using data report.The username is rowena and the password is weng. you can also check the it in my security table in ms access. hope you like it! DONT FORGET TO VOTE FOR ME TNX!

This sample code is an example of how to put text and graphics into a richtext box on a form and then save that information into a database. The example uses MS Access, but should work with SQL Server as well. I needed this for a specific purpose and when I could not find any examples, I created my own solution. Use this however you like there are no copyrights on the code.

This class makes VB Database Applications easy to write on the fly! This class includes over 30 functions for ADODB programming in VB! It encapsulates all the Find Functions, Move Functions, along with AddNew, Delete, Update functions and a ton of error trapping for easy use! Also includes events to program at your disposal! Please leave comments/feedback and vote if you'd like. This is my first class file I have been working on.

my english is bla bla so try to understand my words first i want to thank mr.opal coz of the code he put here about the same thing printing flexgride. i want to say to mr.opal great mind = great code but vb has a great tool called DataReport what u need to deal with this tool is imagine take ur mind a way. if u don't understand my words u will understand my code.

This code simply binds a ListView control to *ANY* kind of database you want(Access, MSSQL, MySQL etc...) It also includes auto column resizing that resizes column headers relative to their content.

I needed to query 2 password protected Access databases with a single SQL statement. The Microsoft web page http://support.microsoft.com/kb/113701 was helpful and gave me hope that it may be possible, but was not too clear. I use ADO with VB6 whereas the Microsoft example was for VB3 and the old ODBC. The Microsoft example worked almost straightaway for me if the databases had no password protection, it was the password protection that made it more difficult. Eventually after quite a bit of experimentation I cracked it and I thought I must share this with fellow coders in case they have the same requirement.

Graph designing is one of the most important feature of database programss. This code allows you to design graphs at runtime! It can also read from a database that you can open and display it graphically. It allows you to chose from a list of chart types including both 2d and 3d!,it allows to save graphs to bitmap files!, copy graph to clipboard,print the graph and lot's more.

For people who still use the DAO data control to acess MICROSOFT Access Databases , Here's what's been missing from the control , A way to access a database with a password

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

A Library Management System using Microsoft SQL Server database in the backend. This project can also be implemented on Oracle by only changing the ADODB.ConnectionString property. Before working on the project you need to create the normalised tables, I've provided with the (DDL) SQL commands to adumbrate you with the structures for the tables used in the project. My Local Server name is BasuDip you'll need to modify this in the code. A screenshot of SQL Server Enterprise Manager is provided for reference. An updated code on Calculator is also included with the project. Hope you like it, your inspiration is solicited. Please vote and/or post your comments.

This tutorial will show you how to create a Visual Basic 6 project which will generate a report using Seagate Crystal Reports 8.5 Developer Edition. You will save the path of the image files in a MS Access database where it is protected by password. This project will use an external Crystal Report file and will be previewed using Crystal Viewer control.

Basically it is just a telephone numbers directory. You can search for people whose birthdays are fall inside a range of Date so that you could call/send SMS to them to wish them :-). Support Chinese name as other name. Use MS Access 2000 database with password protected. Auto compact database and update birthday when unloading the program. Auto resize MSFlexgrid column width when vertical scrollbar appeared. Use text file for simple program settings and write error log. Easy to use First, Previous, Next and Last records and string Find function. Easy to Add, Save, Edit/Update and Delete records using Hotkeys. Updated 12 October 2007: Leap year bug fixed and also show age in MSFlexgrid. Support empty birth date whether only Day or Month or Year is inserted or combination of 2 or 3 entries. Use Dateserial function to fix date problem. P/S: Searching birthday records stored inside a database is not easy. I hope this program could help someone who are looking for an idea to solve the problem.

Example shows how to connect to an Access database; browse, add, and delete records.

Enter your SQL server's information, and easily select a table (or all of them), and the application will print the Table's Field properties... Great for a quick-reference. ****BE SURE TO SET THE CONSTs IN MODULE1 TO REFLECT YOUR SERVER SETTINGS****