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

This program generates code for a Microsoft Access database that the user selects. The generated code will declare the connections as well as open and close the connection. This code has a lot of examples of coding with ADO and grids. I have lots of comments in the program.

the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).

Converts your code ISBN to Code Bar. Convierte tu codigo ISBN a Codigo de Barras.

Version 1.0.13: added some error handlign. NEW! Added functionality: now it works also with password protected access databases. Update your new database from your old database at amazing speed. The program updates all the tables from the old database to the new one. If you find anything faster than this please let us know. Enjoy

Everyone knows how time consuming and painful could be query code writing. This application is the MUST for all Database programmers who want to make their life a bit easier. The application allows generate and format chunks of code ready to be used in your application directly from Database. Start the Application and press Help button for further instructions.

Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. [email protected] Please Vote....

Give you an idea of how to store your friends information Better version than earlier. Download it now and try it. Please vote me. Thank you!! If any bug please report, thanks.

This code shows how to use an array obtained from 'GetRows' and navigate through it as though you were using a pageable recordset

The problem with Access databases is that when you delete records, the .MDB file doesn't shrink. It just grows and grows and grows – until someone either compacts it or you run out of disk space. This tip will show you how to compact a JET database up to 100 times!

MS Access developers will be amazed at this solution. Smart form requires zero programming on your part. What if you could intercept the MS Access sql statement before any database transaction occurred and record this statement in a journal, would this be valuable to you? Of course it would. What if you could replay the journal DML entries in the event a database crash occurred, would this be of value? If you haven’t solved the transaction problem you’ll love this article. Spread the word through the news groups.

Megacomputing - Waren Sortiment, enables yor Store your Sortiment, Computers Hardware etc in a database, with price EK _german buy price , and Sell price VK it wars prog for my hardware store i need it ************************************************ Updatet: Some bugs Fixed.

Backup and Restore your Outlook Address Books contacts. You can save your contacts as different profiles which means you can maintain different contact books and restore it whenever and wherever you want! Saves you considerable of time and resources since your address book is now intact and is stored in a Central repository. Ideal for a network environment with a central Database server(SQL Server, preferably).

I am doing a project for a retail system. In the design time, I need a command button for simulate the pageup and pagedown function for flexgrid. I have found no code reference for this function, so I post my own code here to share with you. Your feedback is welcome!

Very simple application that stores information about software. Stores Title,Serial#/CD-Key, Company/Author. Most significant thing is the use of DAO 3.6 to manipulate the database and write the report for printing. Code is commented, and clean. Limited error-checking and input checking. I do not plan on doing much more with this program, other than use it to keep a list of my own software. Please give me comments, votes NOT needed or requested.

This code lets you add a new table to existing database in SQL Server programmatically. Useful when developing a database application for off-line users. Simply send an executable through e-mail, and let it run once.

This project demonstrates a number of important ADO Data Base - VB methods and utilities. 1. Paramount of these utilites, from my perspective, is how to get the totals from a database field as well as how to multiply the items in two DB Fields and then create another field to show the answer. In addition a running total is kept, showing the Sum of the multiplied fields. This is a feature that any inventory data base requires. 2. Make an ADO Connection without using the ADO Data Control. When a program uses the ADO Data Control(s) it hard connects the data base to a given directory ("C:\My Documents\MyDataBase.mdb"), or worse yet the directory that the program is design / built in; (C:\Program Files\Microsoft Visual Studio\VB98\MyDataBaseProgram\etc"). This connection causes havoc when the product is installed to a client's computer. Of course a work around for this is to make a DSN Connection, but this requires the inclusion of numerous files in your setup/install program. When the connection is made through the use of code as opposed to using the ADO Data Control the Database file is located / installed in the program's deployed directory and is easily connected to. 3. Deploy and show all of the data using the MS DataGrid Control. Program shows how to fill and set the Data Grid. This demo allows adding and deleting of records directly on the Data Grid (Although this method is not recommended due to lack of ease, the better method is to use the programs Text Boxes). 4. Program sets up a TextBox and recordset movement procedure that emulates the familiar data control methods, i.e., The user can move through the records - movement is apparent in both the Data Grid and the Text Boxes, and the Current Record and Number of Records are continously displayed and updated when records are added or deleted. 5. Program makes use of the MS Report Designer in lieu of Crystal Reports. I have used Crystal Reports in the past and had numerous problems. I now use the MS Data Report exclusively. If you have any questions/problems with this demo it will be in this area. Study the DataEnviornment and DataReport Designers Structure

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.

Generates Insert, Update, Delete and Select stored procedures for SQL databases

This tutorial aims to provide an intermediate Visual Basic 6 user with the basic skills required to retrieve and manipulate data from many commercial databases and any ODBC compliant database using the Active Data Objects technology. It includes a sample project and a full tutorial in Word format. The html version can be seen at http://users.tpg.com.au/jaqmar/adotutorial.htm.

a simply sort on de collumsheaders of a datagrid