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

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

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.

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or [email protected]

Using ADO: This is a demonstration of how one can take selected items at runtime from a user, create a parameter query using the selected items and then run the parameter query.

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.

Class that allows to create or edit connection strings using datalink of ADO. Suggestions and commentaries are welcome. Vote me!!

For beginner database programmers.

Second code for managing database series. Querying with SQL and basic dictionary application. Enjoy it.

This code will save and retrieve bitmap graphic files from an OLE Object field inan Access 97 database. The same principle applies to earlier versions of Access/VB, but I haven't tested them. You'll need to use the appropriate DAO library. Let me know if you find a way to save other graphic formats.