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

This code creates a Microsoft Access MDB dynamically.

VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.

It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.

This simple little function just returns the total number of records in a ADO recordset.

A utility to import/export Access database from/to other application formats, e.g. Excel and text files (single field or delimited entries for multiple fields). With sample files and help, as well as ample remarks. It is advisable to run the sample files first (and read remarks in each frame). Once you are familiar with the pertinent rules, you may then begin to use the program to process your other files.

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 [email protected]

Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.

Convert a database table to HTML

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 "single-form" utility program, to be used (1) when one does not have an Access program in hand, but wants to create an Access DB or to modify the structure of an existing one, or (2) if one wants to include a simple form as a handly tool in a project involving DB. The program provides functions (i) to display the hierarchical structure, properties and other relevant information of a database; (ii) to rename or delete tables/fields/indexes/queries (or delete relations); (iii) to create a new DB from scratch or by copying the selected tables from an existing DB, with or without index and/or data; (iv) to build a new table with specific field and index property settings; (v) to re-start an auto increment field; (vi) to print a table structure; and (vii) to browse &/or copy records, etc.

For ADO database application: To show (1) How to use ADO schema to obtain a list of tables of a database. (2) How to provide a re-usable single form for any MDB file name, and with another form to display as many tables as there are in that database at the same time. Otherwise, you will have to repeatedly create/refer to an instance of connection and you may need 10 forms if there are 10 tables in a database (see "3"). (3) The possible techniques to enable opening several tables on the screen in the same session, yet without conflict (otherwise if you create 10 instances of the same form, some common event handlers will mix up Table B as Table A, e.g. when calling yet another form. But with appropriate techniques, this conflict is avoided). (4) How to display various properties/attributes/status in descriptive text(pneumonic), rather than the VB's original numeric codes. Note: MS TreeView itself limits the node count to 32767 only. (For a comparative study of DAO, refer my DBofDAO)

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.

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