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

This code will teach a user how to save their data and also how to retrieve it. Very easy to understand if you read the ' comments. :) Enjoy!

((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.

visual user interface to construct a query

How to copy a database table. This may require some tweaking.... "Bill Pearson"

A short routine that backups the tables from an open Access database George Kinney

The following function creates a user. You can execute it under any user you like. [email protected] (Dror Dotan A')

This project demonstrates populating a Microsoft Access database dynamically into a treeview and listview control, by using loops and arrays. Also added the common Add/Edit/Update functions into the database for those who wish to learn the basics functions of ADO. Another purpose of designing the code the way I have with objects is so you can reuse the listview and treeview modules just in case you wanted to load the same information into another treeview or listview control, with out adding extra code. Once any database is loaded you can also edit the values in the treeview with the label edit functions. (F2). anyway there are lots of code samples available in this project. if you like this code please vote. Thanks.

*** A1 Database Copmarison Tool.... Can compare 2 databases for missing Tables.... Can compare 2 Tables for columns and report the missing one's... Generate the Create Table Script... Run the generated script on Target database.... lot more to come.... Uses ADO DB Objects... Can connect to MS Access NOW... SQL Server , Oracle , Foxpro etc ... later...

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

Ado Database which stores Usernames, Passwords, Notes. Passwords are kept encrypted. For the Encryption i used the DS2 Class I found on this site.(Author: David Greenwood)So far the best Encryption - Example I could find here. Uses the Microsoft-Style of Ado Database. Features Add, Update, Delete, Cancel, Edit and a Listbox. See Screenshot! Update available, More security: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=41006&lngWId=1

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

A simple, and easy to understand code, whick lists the tables etc. in a microsoft access database. The code uses ADO, so it is handy for beginners to follow while learning. Sorry forgot to comment it.

This Is a great module, which loads data from a recordset into a listview without all the usual hastle. If you like it please rate it and vote for me. Thanks

This example will show you how to move items from datalist (which is connected to ADO control) to a listbox.

This code is used to store, track, research and share recipes. I got the application about 8 months ago from PSC from a posting by Bob Davis from Tallahassee Florida. I loved the concept and some of the recipes were cool too. I really liked what Bob did but since I'm a database programmer I had some challenges that I was interested in tackling with regards to his initial design (plus I was board) so this is the result with a few added plus's that my wife dreamt up. There is one thing that is bothering me about this application though and maybe you fellow coders can help me out. For some reason I cannot distribute this to any family members or friends without installing VB6 on their computers. They are using 95B and 98? I have traced it down to the Data Access pieces for the errors (particularly the compact and repair commands). I have installed the MDAC on their PC's and it does not work until I install my copy of VB (Pssst, Please Don't Tell Bill). If you have any advice or critisisem, go ahead and let me know because there is always a better way, a different perspective or something that everyone did not think of. Pardon some of the not so neat code. ;-) Best Regards, Tom Williams

Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001

This is a Contact Data Base with to organize our personal contacts or company contacts. This code have other features like Login User and Password, add contacts, delete contacts, edit contacts, search contacts, Print contacts, send email to our contacts without a external email program, a calendar and a digital clock.

My third submission to Planet Source Code demonstrates how to use ADO and the Datagrid Control together. One neat feature of this app is the use of a horizontal scroll bar to move through records. I haven't thoroughly tested this app so don't be surprised if you find a couple bugs. If you're new to ADO or even a novice I'm sure you'll find something useful in this app. Please vote and give me some feedback!

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 !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!