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

This project is based on CODE_UPLOAD1185011192000.zip. I added a Class structure to the Server and added some other checks. This upload is a Multi-User Server/Client project. The Server has also a very reduced sort of database behind. Every user can create one or more buffers which should act as a one-dimensional recordset. The buffers are being filled by a simple Selection statement. The purpose of this work is to figure out if a simple database server could be built up in this way or if you have to do it totally different. I'm actually looking for some critics to understand why this is a good way or why not. So please give me comments. No votes needed.

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

Helps to maintain credit customers, with the details of bills and outstanding balance, etc. Useful for small companies, total solution. No need to purchase big software which has got too much unwanted functions for which you don't need to pay for. The code has got very useful stuff like managing ADO DB, creating reports, etc... hope you like the code and most of all the application. Most of the reported bugs are fixed (which were a few ui bugs). Check out now the update.

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. You can browse for photo images on your harddisk with the filebrowser included into the OCX. This browser also remember the last directory. This code is well commented. Just click on the ocx, drag it on a form and start programming. This code has not been tested on SQL server jet. I've included a sample application to show you how it works. I hope it will be an attribute to your programming needs. For any comment mail me at Tigersoftware@rodneysafrcomputing.8m.com Have Fun. Rodney Godfried

This code will allow you to populate DBGrids and other bound data controls using a Data Control, SQL, and an ODBC DataBase.

The project has two forms. Both displays charts using mschart control for a data from access table. One form displays a chart(2D BAR) for the first record of the table. The second form displays a chart(2D BAR) for a set of records. 1.Both the charts displays legends. 2.Both the charts displays titles for X and Y axis. 3.Both the charts accepts a title to the chart at the desired location. 4.Both the charts displays data values at the desired location above the data points of each item. 5.Above all, the second chart(in the second form)displays bars in the charts dynamically as and when records are entered. i.e., if there are five records, five sets of data series will be automatically displayed. 6. Column labels and row labels are named in the code itself. 7. Filling colors to each data series is mentioned in the code. To summarize, a customized graphical representation of a set of data from an access table can be created by any user.

This is a veeeery simple code to make one autocomplete textbox that gets the first letters you typed and searches for the most similar word from a table and then completes the rest. No API Calls, No Classes, Only few lines of code in 2 events...Simply save it as a module (.bas) and add it to your project

This is an example of a DAO DATABASE CONNECTION PROGRAM Este es un ejemplo de un PROGRAMA DE CONECTIVIDAD A UN BASE DE DATOS POR DAO. This program contains an english part, for those that speak english. Este programa contiene un parte en español, para aquellos que hablan español.

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.

This is the database editor version 2. I did not submit the first version. However, I made changes and enhancements to improve the program. It only works with MS Access type databases. A person does not need access installed on their computers for it to work either. You can create new databases, open existing databases, compact a database, add new tables and change the database structure. If there are any suggestions for improvement, questions how to use it, to give feedback, or even if there are any hidden bugs, please do not hesitate to email me at musictopia@cox.net

Digital Statistics Calculator saves all entered data to a DAO database and can send it to Excel for graphing. The lab where I work wanted this to avoid doing double data entry.

This code will allow you to make a DAO database using code instead of the Visual Data Manager. This is good if you need to make a program that makes a database from scratch on the user's computer. Has many uses if you are a creative person! Please vote for this code if it helps you in anyway. If there are any questions, just email me. Thanks!

This a example for call one or more store procedures with different input parameters or without parameters.

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

This sample program is just used to show you how to load the entire Database into a Tree View Control. (*This sample is complete DataEnvironment based.) The Recordset(the Command Object in the Data Environment Designer "Database") can be set by property pages in the designer. But here for the ease to use, I let you browse an Access MDB file. In fact, you can use any type of recordset(Excel, Access, DB, SQL, OBDC...).

To generate Payslips

This is an application that allows you to connect to a database and view all the properties of a stored procedure and writes the VB and ASP code for you to run each particular sproc you are viewing. It is a pain to have to write wether a sproc parameter is inout or output and what type of parameter and what is the max length...etc. Just point to the sproc and all the code is created. There's even setting based on how you would like the code written for you.

Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.

UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.

This is an app to organize and keep track of the different recruiters that I have been dealing with looking for a new job. It stores all of your contacts in an access database, allows you to search on all fields, sort on Company Name or Contact. Allows you to send email or go to the recruiters website. This is my first submission to PSC. I would appreciate as much feedback as possible (Good or Bad),and some votes if you like my code.