From codeuu,source code
Store Files to Access-DB and restore them from DB to File and more...
Read from and write to a database on a web site via simple ASP pages from within a VB program, if you do not count DIM statements then this is all done with just 4 lines of VB code (+ 25 or so in the ASP scripts). Uses ADO & XML.
Intergrates Act 4 databases into access 2000
Give you an idea of how to store your friends information.Please rate me after downloading my work. Thank you! *version 1.1 is out
Keep track of your companies notebooks, Laptops, Desktops on a two week checkout policy and print a receipt. Still working adding reports based on checkouts by department's, employee's, PC's to track problems within certain areas. Use in system tray for quik and easy access, and view as a calendar style app or just as an image on the desktop.
address book to keep records of address book,pls feel free to give comment
Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. chris@hatton.com
Give you an idea of how to store your friends information
Very simple application that stores information about software. Stores Title,Serial#/CD-Key, Company/Author. Most significant thing is the use of DAO 3.6 to manipulate the database and write the report for printing. Code is commented, and clean. Limited error-checking and input checking. I do not plan on doing much more with this program, other than use it to keep a list of my own software. Please give me comments, votes NOT needed or requested.
A complete Database application. Based on ADO
A Simple Love Calculator..
PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-)
PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-)
Create an MS Access Style Combo or ADO DataCombo using a class and a single property
Personal email address book that opens directly the default email software, copies and pastes the address selected so as to be ready to write and send an email message.
The purpose of this app is to show some basic operations on databases using DAO 3.51 . Very good for begginers.
Thanks to Collin McAllister for the 7/13/1999 submission this is based on!!
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 :-)
I have noticed recently, how many people have been going into the discussion forums and asking how to use databases.
Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected.
A Quick & Easy Search routine for ListViews AND Recordsets -- hand in hand.
I catalogue this program like an utilitiy
Automatically generate a function to create an Access 2000 Database With ADO. I catalogue this program like a utility. This utility generates a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Verion 1.1.0!
You can use the ADO conection object and link it to the ADO Data control thru code. The sample keeps a history of all the gas price changes. The conection is easy. Comments welcome.
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.
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
This is an address book with cool GUI (using only basic controls and no API). Requires Access'97 .Dont forget to rate this thing.
Demonstrates many common VB controls, ADO databound controls, Datagrid, and input validation in a VHS movies library. Hopefully demonstrates good code style.
Same as ABCStores, with search and filter implemented. Remember to uncheck Archive property of the ABCStores.mdb
Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste".
This Software will print the tables data of Access/SQL Server databases in ASP/Html format and save it in .asp/.html files.Please give me your feedback and votes email:-deepakmailto@rediffmail.com
Self contained Calendar, with a input form, display page and access database. Uses ado, asp, automatic form validation in javascript and asp.
This application was really made to store Project Information about our group, but was now published to the public to share knowledge on Data base Programming. The application is very simple, and uses 3 Components, MSFlexGrid, ADO Data Component and DataGrid. Acid Project Base is a simple application that Stores, Aplicable Search engine, and Removes data all from one Simple Microsoft Access Data Base ! Please Vote for this code =)
Stores CD-Keys, serial numbers and registration information for software. This shows database functionality with viewing, adding, deleting and updating records using DAO as a reference. Also, shows using the database to authenticate users, a simple encoding and decoding mod is included to somewhat encrypt the data in the database. This is worth the look, even if you do not plan on using the database. Sorry guys, I only include the database structure, not data. No serials/keys included. That's illegal ;> No votes requested, however I do like comments on how to improve the code. I will be adding comments when I get the chance.
This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)
ADO Recordset Paging in VISUAL BASIC !!!
I wrote this code when i was developing a software for an Estate Agent.
This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]
Small but has everything: Ado 4.0 Access2000 Database; Adding, updating, deleting, editing and printing. 2 different kinds of searching ( 1 thru a listbox, the other 1 thru a textfield ). Microsoft Outlook 2000 support included. (creates a new mail).
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 Code, is quite simple really, it Searches
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
We had a client who 'accidently' copied one databse table into itself causing duplicate records. Unfortunately Access only allows 10 columns in its De Duplicate wizard and we had twenty! This code allows you to pick the database you want deduplicating, lists the tables and the fields within the table so that you can chose the 'key' fields to deduplicate on. Then it creates a table within the database which contains all of the deleted duplicates from the table you chose.
This program convert Access Database to the MySQL database. It has many functions like Copy Full Database, Create Only Structure, Create And Copy Database, Create Table Structure, Create And Coppy Table, Coppy Only Row etc ... I made some examples with it and although i used an access db with 100 000 records it did not gives any error.
Want to work with MSACCESS database? This code is for you. You can perform add, update, delete and searching operations on database. Best part is the searching.UPDATED WITH FULL HTML HELP ON 9th Oct. 2002.How to write to registry is also explained with full error handling.Please vote for me....
address book
Cant remember the important things in your busy schedule? Then have this code (Using MS Access Database). This code reminds you on the date and time set by you by a popup window which will be on top of all running applications. Prpoerly commented. You can reschedule the reminders. Can mark them as pending a or done. At start up checks all the reminders which are not shown previously bcoz this application was not running at that time.when you close it (by X) then it will be in the system tray.Dont forget to vote for me.
This is a little program if you have a table on SQL Server and for example wants to select 200 rows for each department and you have 2000 departments to select for. And maby the should be selected randomly and only those with phonenumbers. This tool will do the trick.
This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.
This little program can transpose data from a multiline per customer table to a single line table. The program will create a new table and add transpose values as fields and then set 1 or count occurances. (flatten file)
This is a basic example of how to use an access database in an application.. an address book... It has options like search, add, delete, view all.. again, just an example
a simple transaction that adds, edit,search, and save customer and product information... hard coding of connections... great for teaching purposes
It's not true you can't use Seek with ADO in Access.
I am doing a project for a retail system. In the design time, I need a command button for simulate the pageup and pagedown function for flexgrid. I have found no code reference for this function, so I post my own code here to share with you. Your feedback is welcome!
Ever wanted to find a special value in a database, but don't know in which table or field it's in. This tool helps you scan for a value in a database with 1 ore more tables in it. Only works on SQL Server. This tool can match exact or "LIKE" querys and has some other features. If you like it, improve it! :) (and tell me about it)
This is a simple address book. It takes 5 minutes to make and is really useful. The one bad thing is it does not have a list of names, you just have to scan through your entry's to find the one you want. Still, it is pretty easy to work and use.
This will list all tables in an access database allowing you to export the contents to an xml file. This is my first try wit using XML and i would lvoe your comments / suggestions to make this much better.
It is a great visual tutorial to learn about Databases in Visual Basic.
Please download part I at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44040&lngWId=1.
This is a simple program called Softgra's Address Book
Customize the import of text files into Access 2k databases. You can do this with Access and Excel but the results may not always be what was needed.
This saves user and password in a txtfile and restores when u want :=) *simpel*
When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem.
Ever wanted a report of what's in an SQL Server table? This tool generates a full report of a SQL Server table with max/min values, lengths, field type, grouped counts, number of unique values etc for each field in the table.
Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97.
Convert all the structure basics of an Access database to a XML code.
This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.
This example shows a way to manage persistence with classes in VB using a 3 Tier framework with XML for inter layer communication.
Lists printers in Active Directory, installs selected printers and sets to default. Uses Andy Stevens printer module
This is a nice program for Browsing through the MS Access file i.e. *.mdb. It works quiet fast comparatively. This shows you the number of tables present in the selected Database. Further it will show the fields in the selected table.Theres also a provision for seeing the whole selected table in the grid. Its quiet a good thing for using & even for the users who are not well known with the usage of Access Databases & dealing with the uncertainity tables into it.
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.
a Crystal Report TTX example
This is an update to one of my earlier submissions "Compact and Repair". I've added new functionality that will allow you to run any macro or query that the selected database has. Currently I am not handling parameter queries, so if you try to run one of these it will most likely crash the program :). The code for populating the msflex grid is not mine, I forget the name of the author.
This is an updated version of one of my ealier submissions "compact and repair". This version allows you to run any macro or query, it will also display any table.
this code is made for experimental purpose only. this program recovers the database password created in MS-ACCESS 97. THIS program is created for learning purpose only.
ADO ComboBox - Lists items from your Database
ADO ComboBox (Update) - Lists all the items from your Database
The applet Updates a database with downtime reasons
(PLEASE RATE THIS CODE)
This is my first program in VB. Address book with easy to use interface and fully controlled through keyboard.
- how to use the ADD-In manager (Read Readme.txt)
A viewer and editor of a database with 10,000 computer acronyms.
we can use this software for any institute for their admissions. and it stores all the data in one database
converts Access tables to MySQL tables. Includes Primary keys, indexes, copies data and can put a link to new MySQL table back in your Access DB
Learn how to create and use a disconnected recordset with ADO, ie a recordset with no active connection.
Allows Access 2000 Database users to produce a wide variety of filtered reports thru an easy interface. Many of my clients do not want to use the Access Report Wizard. This allows them to produce elaborate report filters on their own. this is upgraded version to show two methods of using a report factory, basic and advanced.
This project was developed to help those just starting or wanting to start usind ADO and MYSQL Database. Contains a module that creates a MYSQL database on the fly. Hopefully this will help some of the new people get off the ground with ADO and MYSQL quickly and learn the full capabilites of using this combination. Please read the Program and Module notes before running.
Add any BLOB you like to an Access database. For example, add pdfs, docs, mdbs,zips etc. All the different types are displayed in a tree view and you can view them by dragging into a frame and launching their respective application.
ADO Control
This Software is designed using Microsoft Visual Basic 6.0. This Software is a Beauty Pageant System wherein Judges can vote via network. ACSAT Beauty Pageant System is developed to secure the votes of each Judges in order to avoid misconduct judgement.
It simplifies the generating of code for sql searching.
A simple example of making a login for a program using ADO with an Access database. Also allows you to register new usernames and passwords. This program could be improved upon by adding a Primary Key to the database and a few others. I just wanted a simple login so I didn't take the time to put in any extras.
Would you like to add an XP style login to your application? This login will allow you to register and will not allow duplicate usernames. You can also change the color scheme at login. You will need OsenXPSuite for this app. Uses ADO to connect to the Access database.
Parent Child items in a database table is a well-known issue. Hierarchy in just one table of
I built this for our help desk at my job. It has some good examples in it for different things so I thought I would post it.
Keeps track of student record and payments. It also tracks student with old account and credit it to new account..
This is a database purely written in Visual Basic. Gotta check this out because, it doesnt use any API's, User Controls, and even modules or class modules. You can store up to unlimited pages (thats what I know) with 10 rows of data per page. And it is written in a unique extension file (I hope) and has a unique way of storing its settings. The trick is the powerful InStr() method. I hope you'll like this idea. Simple yet useful and, plus it has a search tool. Please send me some comments, that'll do. Anyways, if you think that's too "beginner", well I am, just started doing visual basic in 2 mos, well. I hope it'ss be useful.
to make library more compact!
I've seen lots of submission here dealing with databases on SQL. So I decided to create a crash course on SQL to explain what those SQL syntax mean. This is useful for beginners out there as well as for advance users who miss somthing in SQL. All SQL commands used in here are well explained...Have a nice day !
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
Checks your Access Database for Reserved words.
Can execute select query in access
To quickly access URLs without having to go through a myriad of dropdown menus in you browser.
CAsh Book, Bank Book, Journal Book, Combined Book, Balance Sheet, P & L, List of Account,
This is a good example of access database, for beginners, add, edit, add UserNames to list box and browse trough it. Very simple to understand.
Using ADOX, this little program will get the SQL query strings from an Access database and add them to an Access database. You could use this to document the queries in a database or to seach for a specific string within a query. I use it to find which quries update a certain table in a databse I have inherited at work. It speeds up my workflow.
An application that allows you to open a Microsoft Access or Foxpro Database and then run/execute sql queries through them. uses ADO,datagrid and common dialog box. Please vote! tnX! =)
Database
A simple application for managing a farm's inventories.
Address Book for keeping record of your customers and queries of them. Reports included.
Need to go back to basics or need a refresh on the generic database connection using ADO. then feel free to view and study this code. This is a back to basic simple date. But be aware it uses reference and code not the control.
This class is made to access dbf file. This class can read and write to a .DBF file. This class can create a new file, and creating fields as well.
To show how to ADD / EDIT / DELETE information
This code generates SQL code from an ODBC database with the click of a button
If you use Dynamic SQL this test project will show you how to handle apostrophes when they appear in your strings. Unhandled - they cause errors. Note: If you use parameterized ADO command objects this problem is handled for you.
This VB test project demonstrates how to insert, delete, update and select from a Microsoft Access database using parameterized stored queries and ADO command objects. .mdb file in included.
This code is just an example of using DAO 3.6 for access 2000 databases, it is just a small project i was working on to use the skills of connecting to a database, and then a practice on building a webrowser, then being able to launch the browser from another application, I think anyone learning how to use VB database utilities may find this code a bit useful, Those with intermediate abilities may find it a bit boring
((UPDATED!!!)) I commented the code and added a "Generate Character Stats" button on the Add Character form... I still need to add some rules for the generation. This is a new program I am just beginning to work on. I would like ideas on what to add. It is far from finished, but like I said, I would like some ideas. It uses an Access2000 database (included) and I have included an executable.
Basiscally for my grade I made this program which loads up a database with everyone's schedule. Then it compares the schedule with the current person's and shows who is in what class. When you use it for your highschool I recommend you complete the autoupdate and use room numbers because, that is the easiest way to get what class someone is in, rather than Teacher and Class. Make a webpage which gets the Info from a person and make a database out of it. I hope you guys like it
visual user interface to construct a query
My third submission to Planet Source Code demonstrates
You can use this source code to store informations(number of Cd, name, performer, duration ...) about your MP3 song in Access database. You can also edit your data and delete them and then recover it from recycle bin. There are print option (I use Data report in VB6), and you can first made and querry for what you want to print and then print your selection. In Data report you can export selected report in htlm, word or text file. Some bugs are possible, but I work this during the temperature of +40 celsius. There are no (still but I will in future) code descriptions and all forms are on serbian but I think that there are no difficulties for understanding and translating (I was lazy) all of them.
This code is an ADO data provider for NCSA Log Files for web servers. This class module allows you to bind controls on your form to the log file. This could be used for browsing through the data, putting it into a flexgrid, binding to a chart control, etc. Interface for querying data. The focus of this code is the data provider class, not the form. The form contains a small code example of how you could bind to this provider, not what you should do with this provider.
This program will allow you to physically map fields between two Access databases and then transfer the data (overwrite or append). You physically map it by clicking on an item in a list and then drag a 'Connector' object (just a bunch of lines thrown together in a class) to a field in another list. This code has been tested minimally. Please let me know if you find any errors. I will fix them. Thanks for your vote. All constructive criticism welcome! This is my first submission so help me out.
This is an improvement on my previous Access Field Mapper. This program allows you to open two Access databases and Map fields between two different tables (performs AutoMapping as well). After you've finished mapping the fields you can transfer the data with one click. This version will do type compatibility checking and if you transfer data that is not directly compatible it will coerce it for you.
Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures for Insert, Update, Delete and Select. Two methods for Selects are shown - one using a recordset the other using command object output parameters only which is faster by avoiding the creation of a Recordset object. A SQL file is included. This project runs on Northwind db.
3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.
On numerous occasions i have had to Attach or detach a SQl database.So i have written a small app to make this process simple. All comments and votes are welcomed.
This code demonstrate how to connect to database (Patients97) using ADO code alone. I also demonstrate using the MonthView control and MSHFlexgrid control. The database called Patients97 contains customer details like name , address, customer number etc and appointment date and time. On the form, I have an MSHFlexgrid control, a MonthView control and a command button(cmdViewAppt). Clicking the command button connects to the database using ADO code and the details are displayed on the MSHFlexgrid control. You can display appointments for a particular date by clicking on a date on the MonthView control (MonthView1_DateClick event) and the result is displayed on the MSHFlexgrid control. I have not figured out how to create a report yet. What I'll like to do is to be able to pull the information on the MSHFlexgrid control and display it as a report which can be viewed and printed.Preferably I'll like to use the data report designer but I won't mind using excel or word or is there a way to use DataEnvironment designer? Please e-mail me any improvements or additions at supo@orimogun.freeserve.co.uk.
This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.
The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks:
This article demonstrates how to access and update large text fields (Binary Large Objects/BLOBS) using ActiveX Data Objects (ADO). This is accomplished using the GetChunk and AppendChunk methods of an ADODB RecordSet's field object.
Lists records into a listview control using basic SQL Statements.
Allow connect to Access 2000 database on runtime and make exe whit VB5
Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid.
You can choose 2 Access-Files and choose a table of these, to get the table-content of the second into the first.
IIS Application uses SQL and ADO to search add edit delete and browse fields in a database (User authentication Add User Add Appointments Full control of the Database) you need IIS for this one to work must have ASP support installed also this is excellent code folks and opens the door to many new and great database driven websites E.G. Napster replacements thats what im working on now going great lots of coding though any of you guys wanna get in on this let me know cody76589@aol.com
DAO based database program with many features in it, I also noticed after
If you have ever tried to access a FOXPRO 6.0 Database that is linked with other FOXPRO 6.0 Database(s), you will find that it is impossible to do (even with Microsoft Access 97 / 2000)... until now.
This Project Allows the end user to access a MSAccess Database through a Client Winsock application, without having any Data Access Components installed on the local machine. This also allows fast read/write access through modem, or a dead slow computer. The client app sends the server a few strings and then generates an SQL statement, and then does all the hard work and sends back the results to the client.
This Project is an example of how to open a file into a byte array and
Populates a treeview with a database's tables then uses the node click event of the treeview to populate a data grid.
This is another small utility project that I put together to help me index some master records.
Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control.
Provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any!
This code will print the contents of a .MDB using the VB printer object.
The prodram look just like Access, so don't be mistaken. IF you won to learn how to work with databases- the answer is Quarantine DB. The program uses ADO and DAO. With QuarantineDB you can work with, create, delete, rename tables and queries, add, delete, update records. You'll learn how to work with MDI form. Just try it and don't forget to VOTE FOR ME. e-mail : kicheto@goatrance.com
This project is based on CODE_UPLOAD1185011192000.zip. I added a Class structure to the Server and added some other checks.
This program is designed to teach the user how to load data into a FlexGrid from an Access database and then manipulate the FlexGrid to perform typical database actions such as Add, Edit, Sort, and Delete. The database manipulations are executed with ADO methods
This OCX will helps you to retrieve all types of images supported by the Visual Basic Picture box in one line of code. It save it to- and read it from an access database. It support Ado and DAO.
Create an Access Database shortcut (*.lnk) file on the user's Desktop. Useful for passing the /wrkgrp parameter, if the user needs to join a workgroup.
This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases.
This is a new version. New additions include 2 types of code, one project-based the other snippets and functions. More settings added, including large or small toolbar icons, dock list on left or right, activate and maintain transparency. Checks to see if the program has run before, and if not, it sets up the default Registry settings, and if so, it just runs the program. Now asks for database location based with the default bein App.Path\codelib.mdb. I am starting to get more reuseable code. Combining forms and functions based on the type of code and user action. I will eventually combine the ViewCode and Add/Edit code forms for both types. It will require a full rewrite of most of the functions and redesign of the forms. Also in the works is the program's compiled HTML help file. I have almost completed the commenting of the Sub/Function purposes. Please bear with me as the commenting of the code is not the highest priority, getting a working, useable application is the priority. I have included two (2) versions of the actual database: codelib.mdb-Access 2000, and codelib-97.mdb-Access 97. Please leave me comments and questions on the code itself. Votes are appreciated, but not needed. I would rather have the comments.
PlanetSource code is a life for VB programmers. I have learned many thing from this website so I felt I will give this code to all the programmers who are willing to learn the database concepts.
This code is essentially used in client server programming, but i have either commented or removed such lines of code in order to enable programmers to understand database and client server programming.it is very well commented and is very easy to understand.
Allows you to dynamically select vehicle year, make and model. 'Dynamic' meaning invalid makes for a given year aren't shown, invalid models aren't shown, etc. Pulled the data from the source of an MSN Carpoint page and played around with it for the heck of it. Decided to upload it in case someone needs the data. Contains all US vehicle makes and models from 1985-2001.
This code will show you how to connect to a mySql Database using a DSN. It is very simple program but it shows the basics.
There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.
This Application is used for quick access to an Oracle Database. The DataFetcher gives you power to Add, Remove, Search, View, Records at a click. DataFetcher also has it's own built in SQL*Net emulator in it! If you access an Oracle database frequently, then this is a must have Application. You must have Oracle Client installed on your machine to take advantage of the ORacle Object used in this code. Please Email for any questions or feedback. Thanks.
Some SQL Server actions:
Updated ver 2.0. In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch update. This app shows you how. ADO data binding without Adodc control, database file creation, table creation, and combo box data listing and click to find a record is demonstrated. I appreciate your comments.
My code is a way to password protect a cd, so that only a certain user can access the setup program, it also allows the user to choose which one of the cd drives its in.
This uses a Microsoft Hierarchical Flexgrid Control 6.0 which is an OCX control of your VB6. This demonstrates on how to relate different kinds of SQL using ADO. This provides tutorial to all. Don't forget to vote for it.
This little bit of code and table will help you manage tables with linked/split databases.
This is in response to a 'Request for Code' in the discussion forum.
Don't miss this guys coz' this is a corporate code that i developed before using ADO with complete Login Entry,Masterfiles,Transactions such as Sales Order, Purchase Order,Receiving Order, Reports such as Inventory Report,Sales Report,Critical Report and Backup/Restore/Password Security features. Using this example you can learn a lot about how ADO really works without using any data controls. This is the best contribution of mine in PSC so far so you better not miss this coz' this code really rocks. PLEASE DON'T FORGET TO VOTE FOR THIS CODE COZ' THIS CODE REALLY ROCKS!!!
I have received a lot of responses to my code posted earlier ( a generic object that assisted in returning recordsets from Oracle). Most of these questions have been in the domain of the stored procedures themselves. Hopefully this article and example stored procedures will help clarify.
This is a good little database program I made to log hours of use on one or multiple computers running Windows 95/98. Not only does it add a little security to windows but it also uses a database on a local or network machine to verify
This application was written with the intent to serve as an example of how to use the MSChart control that is shipped with Visual Basic. I've found out, the hard way, that the documentation for Microsoft's chart control is poorly written, if not totally useless! This example might be silly but I garantee that it will help you understand how to manipulate and create graphs, specially for those who work with scientific data (like me).
This project uses ADO connection and recordset to get the sales from an Access Database. The data is then presented in a Chart with the sales grouped by days of the week. The display is in spanish, when you read the code you will know what Lunes, martes, etc. is. Hope it will be of use to some of you.
Convert a ADODB Recordset to an XML String
This code connects to a given SQL server and database and returns field info from a specified table. Handy if you need a quick printout of a table definition and you don't have time or patience to wait until EM has launched and connected to the server.
This copies, renames or deletes stored procedures on an SQL server. Also the ability to copy procedures cross database, or even cross server. This thingy is way easier and faster then the import/export wizard.
This is my second school project. A simple database prog. Stores not only ABC 123 it's stores even images 2
Shows you how you can use a progress bar while reading an MS Access database. This example uses two progress bars, one for reading each table, and the other for reading the entire database.
This code is great for anyone who wishes to connect to any ODBC database using ADO and ASP server side script, and display the records in an table. Code also alternates the colors of the rows. Also provides paging the records, and page control code to allow the user to select where in the recordset they want to be! Great template for quick database access.
Accesses any ODBC database using ADO. Records are displayed in a table withe rows that alternate colors. Paging control code allows the user to select which page in the recordset to go to. Current code has been tested with Microsoft Access and SQL 7.0.
Select ODBC DSN, Test the connection with a select command exec to a systable, gives timeout connection, ip address of the server, test the IP address of any server with Ping (shell command) and writes on Lmhost the id and Ip of the server. Shows the drivers and ODBC information
This program was created so I could clean up files and databases on my system. It allows you to search for specific files and MDB's. You can then select them and either delete the selected items or Compact (if the file is an MDB) the items. The code is more to give you an idea how to search and manipulate files.
This project uses ADO to copy tables from one Access database to another.
This example allows you to have a simple address book containg the persons naem, email and phone number. Not much error checking/trapping but it shouldnt produce any errors. Next version will have an Edit/Delete User function and the ability to search throught the users. Sorry its not in this version butIm loaded down with work.
This is an example on how to make your data access program QBE using the
This will allow you to export data to a number of file types. Be sure to define an Access 97 databases in the MDIform1 load sub. You will need VB6 with service pack 3 to run this. If you have any question… Please let me know. Please note that the JET export to Excel has a problem with NULL values. If it encounters a NULL value in one of the fields you are attempting to export, you will get a “numeric overflow” error. Currently I don’t know of a simply way around this except not to allow null values in the table.
This is an example of a DAO DATABASE CONNECTION PROGRAM
This code will save and retrieve bitmap graphic files from an OLE Object field inan Access 97 database. The same principle applies to earlier versions of Access/VB, but I haven't tested them. You'll need to use the appropriate DAO library. Let me know if you find a way to save other graphic formats.
Heres the update to my Address Book Example that pulls it information from an
since i couldn't find any code that let me connect to an sql data source i
This sample project will show you how to easily structure a query to a DataBase.
This program converts any SQL Server table into a CSV text file.
This code will allows you to dynamically access a database without using
- Access97 Descripton Program !! ****
This code can literally do anything you wish with an INI file. Here are a list of the 21 INI functions that I created. These took me a long time to make, so please let me know what you think. A program is included that explains everything completely...from how to use the functions...to an explanation of each variable.
Stored Procedure Generator for SQL Server 7.0
This code demonstrates how to access a POSTGRES SQL database on a LINUX box via an ODBC connection. The demo ( using RDO ) shows you how to create a table, wipe a table, insert data, select data, modify data and write the modified contents back to the database.
UPDATED !!! NOW ADO -- Now you can connect to an Oracle DB as WELL --
Lottery draw attempt using randomize effect. This is my first attempt on such thing. Please let me know if there is any other way which you think this can be done. If not enjoy!!
It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back
Demonstrates how to connect to a sql server using an rdo connection and fills a list box with stored procedures in the database you specify.
Imports ASCII text databases in any format, to Microsoft Access format.
This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later.
Allow easy input and retrieval of images into an SQL database. Includes class file for easy implementation into your own program and a second project based on making the class into a dll for a IIS server. Will allow you to show pictures from you database on a webpage, input pictures into a database, remove the picture, retreive the picture plus more...
This program allows the user to store names, phone numbers, and email
To remedy difficiencies in ADO, namely single criteria in the .FIND method.
When I saw this recently submitted code about refreshing table links I remember I made something like this and I tried to find it back ;-)
Simply use of SORT , FIND , FILTER and BOOKMARK in menu, and thru the Data Base.
This program works the same as the linked table manager of microsoft access. It is very useful when linking you tables at a computer with no microsoft access installed.
This application connects to a Pervasive database engine (or any other) using relational ADO methods (ODBC). SQL statement is executed to select appropriate records and updated ( rounded off ) with new values.
This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database.
Use combobox to display the 1 side of a 1 to many database relationship. The listbox shows the many side. Displays books and publisher.
This code will take data from the Northwind database and write it to an Excel spreadsheet. Code can be modified to do more complex reports, but the basics are included here.
Read a list of Stored Procedures from a SQL 7 Database and pull their parameters out and format them into code that can be pasted into a code module. This can save a ton of time if you have sprocs with over 20 arguments.
This is an Addition to my earlier search function. This is an ActiveX control. It has 9 search functions, inculding rich text box searches, and text box searches, DAO table searches, and Find and Replace searchs for all three. Has a readme file, that explanes all. If you find an error, let me know. This is my first try at making Active X controls. Please leave feedback!
This takes the last name from the user prompts for the first name and then inserts it to a database.It also checks for duplicate names.
Uses RDO to connect to 2 different (or the same) ODBC specified connections. Allows you to select tables on both sides and creates SQL statements to transfer the Data from the Source Table to the Target Table. Has the Option to Clear or Truncate the Target Table before Transfer. The 2 Tables must have the same amount of fields (of course).It automatically does the single quote thing for the fields that requires it. Easy to convert to ADO. Very nice , easy to use interface. The ODBC connection wil NOT work on NT , although minor changes can easily make this happen. Comments are very Welcome , even from critics.
How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)
This is a small student registration and grading system. I have just done this for 1 day coz my friend needed it so I haven't done a nice inteface on it. Its a simple add, edit, delete and save record. But All I can say is that you can learn different kind of approach in using adodb. By the way I used an access/ado for database. This code is for people who want to know about SQL , Sending report from ADO / Ms flexGrid / flexgrid to Excel, and different kinds of string manipulation techinique. I just hope many people will find this program useful.
This application allows you to remember the task dates of dear ones. It runs and checks the system date and reminds you of the tasks which are in near future.
Fill a FlexGrid without ADODC control and without AddItem of FlexGrid Method, with a fasted time about 230% more... with Recordset.GetString() and FlexGrid.Clip methods
Finds SQL Servers on your LAN
A Visual Basic application development framework for Microsoft Great Plains (Dynamics and EEnterprise) accounting software. This application runs completely independant to Great Plains. (If you require seamless integration consider using Dexterity and/or VBA). The initial version allows a user to login to the system, and select a company.
GoXML is a wrapper class for MSXML 2.0 / 2.6 / 3.0 / 4.0,
This is a database program for a golf company. It was a project that I did in class. The code is for the most part finished. The code uses adds, edits, deletes records. You can send results to excel, and you can also search individual records.
The Grading System helps maintain and organize a secure and dynamic database in an educational institution. This program was mainly a project for my VB class. I'd like anyone to give their opinions/ideas/advice on this program.
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.
This simple demo demonstrates the speed of GetRows Method Compared to movenext method of ADO. The first and second listboxes show this while the third demonstates yet another example and use of getrows, joining arrays of data from a recordset. You can compare the speed of this method too.
This is my first attempt to recreate an Access program in Visual Basic. The results are... I'll leave it up to you to judge it. :)
This is a gym application that I created for my VB class. This App. keeps track of members, employees and inventory. This program uses MS Access with SQL DAO.
This is a cool Keyboard Spy program. This program gets any keys that are pressed on your keyboard and then displays them in a text box on the form.
It is a system based that used to rate students.although it is the backend is MSACCESS it can be converted to MSSQL.. this system is a sample any comments and suggestion please post it... i'm online in rent a coder
A fairly basic INI photo and text database using GUID gen for entries and string encoding for basic file formatting and encryption. Includes Byte arrays for fast image loading and GDI+ with new function for byte array loading and resizing of images. Images are stored in individual separate data files so INI don't get over loaded. If your looking to learn about converting different data types to and from text strings this code will provide you with several very good examples. Their is lots of room for customizations for what ever specific uses you can find for it. I am posting this now because its functions are fully functional and the code is at a basic state so that people wanting to play are not overwhelmed. Please remember to come back and vote.
How to load DAO objects on runtime, open database and select the DAO version
This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.
This is very handy for Database coders, when using events/functions which are only available in MDAC X.XX +. It's professional if you check which MDAC the client is using so your code will only execute if the minimum required version is installed.
vbs script code , using recursion , collections , this code convert xml files into sql recordsets.
Store student information in database
This is an english version of my Hostel Database System that i had submit before. I'm a new in vb programming :). Any comments are welcome...
Everyone knows, that VB's reports can only make static reports... And what can we do to make report from dynamically selected data? Here is the answer: we only need to use HTML Reports - easy and powerful solution for creating HTML-based reports. This is the initial version, I think, that some improvements can be implemented in the future... Please leave your suggestions, comments AND VOTES :-) Thx.
Generate and Read XML Files via the XML Document Object Model. Download this at www.visualsoft-net.de.
data base program for handling files
To Generate a HTML Document for the Table Definition for the given server and database.
A simple example of database use in VB.
I have searched psc for a way to put images on a access database and all that i could find was complicated code so i decided to do it myself and a few minutes later i have come to this...a simple way to store any file on a database field.
I have searched psc for a way to put Application on a access database
This is an applicatin developed in Visual basic for Hall Booking system. The sytem allows you to select one from various availlable halls, it also allows you to book hall in advance.. and then view the bookings. The striking feature is that, its a simple code, easy to understand which can help you to get familiar with database programming and help to develop your own database applications. for any support visit http://www.geocities.com/slazetech
A source code database that can automaticly copy source code to the clipboard when you type a pre-defined 4 character key word.
As the title, I will show in this article how to unleash the power of Microsoft SQL Server Stored Procedures in the most popular programming language in the world: Microsoft Visual Basic 6.
This application handles the basic processes in running a hotel.checkin, checkout, employee record, search guest and employee, payroll, bar etc.
ADO Control.. useful for beginners..
This is a simple database program that uses the data controls.
Like a previous dll I submitted, this one also manages connections to Access/SQL Server/Oracle databases - it's an easy to use datasource you simply send the paths/passwords etc. and create recordsets on the fly.
Complete wholesale product inventory database