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

Convert a database table to HTML

This is just a demo for dBASE files. It will open any number of dBASE files and there is one function which can be used to get data from any of those .dbf files.

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. Useful when you use different PCs with different email software.

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. Programmed using VB6, if you have a previous version of VB you can add the frm file to a new project (However, I have not tried this myself)

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 code will dynamically create an Insert SQL query for a database. It also teaches some things like how to create a database and table though code, how to use the ADOX library, data formatting and etc...just look at the code, to much to write. Requires ADO 2.5 and was created with VB6 SP4. Not tested on anything else. Reasonably good commenting, should be easy to understand.

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

A simple method to convert an ADO set to XML and reverse. Extreemly simple!

When using Autonumber fields in a database for a UID, you might need this value after you add the record, for that record. This is my example of how to get that value back from the database after it is added using DAO or ADO.

The code demonstrates 3 common combobox tasks: 1.) Filling a cbo with a recordset 2.) Setting the cbo Text to a recordset field using a numeric rst field 3.) Setting the cbo Text to a recordset field using a non-numeric rst field

This simple code allows to make an auto-filled textbox (like an adress box in IE). This example uses an DataEnvironment connection, but it can be easy used in any other cases.

Converts the timestamp data type of SQL server into a string that is then suitable for use in a where clause

Haven't made a visual basic program for a long time. Made this for a place that I work. I haven't finished the program yet but couldn't wait to see any comments you make.

Complete ownerdrawn listbox with xp theme support, that can show and edit information from a database. Double click on text to edit the infomation.

how to use SQL to extract desired information from a database

Heres the update to my Address Book Example that pulls it information from an Access Database. I finally added the search and delete functions because I got tired of getting email from people asking me to write the update. :) Sorry it took so long but I've been busy opening up my office... Email any questions you have or comments to plexxonic@softhome.net

Easily Compact & Repair a MS Access Database and display the size differences.

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.

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

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.