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

ADO Helper 2.0 now includes example projects to demonstrate the working of ADO. This will help to directly use the codes in application. Example projects include: Demonstrates how to use Cross Tab, How to handle ADO Errors, ADO Find and Seek Methods, How to use ADO with Grid Controls, Use ADO with Data Report to create Simple Data Report, A complete ADO Unbound example to show, add, edit, save, delete with navigation with error handling, How to practically handle ADO transactions. These example programs will definitely help beginners and pros alike. With the passage of time, ADO Helper will become the complete source of ADO Help and Example programs at one place. Coming soon are topics such as: Data Consumers, Data Shaping, ADO MD to summarize data, Creating Data Sources, A complete payment management system using ADO and crystal report.

Demo for database access class automatically generated by CLASSter. Full source demonstrates calling stored procedures, executing parameterized SQLs, multiple recordsets, batch execution, transaction control, XML processing, error handling, etc.

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 Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.

Ok, Trying this again. I think I have all the bugs worked out. This is a sample of a larger database GUI that A friend and I created thru VB for the company that we work for. If you want the full setup.exe and the cab files (you know if you don't have a full package & deployment options) then email me and I'll send it to you in zip format. (Note: this is a huge file) This is a free version so please all comments welcome as to what more to include, and etc. Please do not distribute this software on any other server other than the original upload to planet-source-code. If you think someone else is interrested or would like this program, please give them the link to this. Thank you so much. We also tried to include as much helpful information with the program as well so, if you are operating it and you have any questions please contact me. So, enjoy.

Im sick and tired of using a third party report generator such as Crystal Reports, etc. so what i did was i mastered Data Report of Visual Basic 6 and here is sample of how to print an image to Data Report using ADO Connections. I hope you like this sample of mine.

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

if u have SQL running on NT this code help you in connecting with SQL server by passing some parameters Like Provider,User,Password etc.After established a successfull connection u can choose tables from the combobox and automatically all records will be shown in datagrid from selected table.

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.

This will read the table form an access database and then creat the textboxs on a form with the field names mapped to the textbox names. It will then create the code to save what is in the text boxs back to the data base

Need Part 11 compliance then you will need multi-level password security with passwords that expire. This sample application will show you how to this to your applications. All you need to do is copy 2 forms, a class module and a module to your application (see below) and you are ready to go. It was written to use an Access database (DAO); I have also written an ADO version, which I will post later. You set up the access rights, add users, and assign these rights to the users. New users, by default, are assigned the password of password, which they must change the first time they try to log-in. A user can change their password anytime they choose as long as they know what their assigned password is. The security file (security.pwd) can be renamed to anything you like and is password protected. You can assign a unique application ID to insure that the security file can only be used with that application. If you are connected to a network, the application will display your network log-in ID automatically in the Log-in ID text box. The passwords can be set to expire after a user-defined number of days.

This shows you how to make an address book with databases.

This is an example on how to use ADO without ADO controls. I use the typical phonebook example... It is a complete application I use myself. You can store your friends, bussines associates name, adress, company, telephone, email, webpage, info, photo and more.... If there are several people using the same computer they could all have their own adress registers... you can create as many as you want and call them what ever you want. You can backup your database to any location you want. You can restore your backup. You can choose if you want to be in read only mode or in editable mode. When you are in editable mode you can Add a new post, edit a post or delete a post. You can send a email to current person or open his/her webpage. You can search for post using several search criterias such as: LastName, FirstName, Company, Adress, Telephone, Cellular, City, Country. The project is made with VB 6.0, Service Pack 5 and MDAC 2.5. If you dont have MDAC 2.5 you can get it at Microsoft webpage. Comments and constructive Feedbacks are always welcomed.

Need Part 11 compliance then you will need multi-level password security with passwords that expire. This sample application will show you how to this to your applications. All you need to do is copy 2 forms, a class module and a module to your application (see below) and you are ready to go. It was written to use an Access database (ADO). You set up the access rights, add users, and assign these rights to the users. New users, by default, are assigned the password of password, which they must change the first time they try to log-in. A user can change their password anytime they choose as long as they know what their assigned password is. The security file (security.pwd) can be renamed to anything you like and is password protected. You can assign a unique application ID to insure that the security file can only be used with that application. If you are connected to a network, the application will display your network log-in ID automatically in the Log-in ID text box. The passwords can be set to expire after a user-defined number of days.

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.

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.

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.

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.

Have you ever try so send a string variable to MS Access that have apostrophes using a SQL Statement? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database.