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

how to use SQL to extract desired information from a database

Easily Compact & Repair a MS Access Database and display the size differences.

Accesses any ODBC database using ADO. Records are displayed in a table withe rows that alternate colors. Paging control code allows the user to select which page in the recordset to go to. Current code has been tested with Microsoft Access and SQL 7.0.

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.

((UPDATED!!!)) I commented the code and added a "Generate Character Stats" button on the Add Character form... I still need to add some rules for the generation. This is a new program I am just beginning to work on. I would like ideas on what to add. It is far from finished, but like I said, I would like some ideas. It uses an Access2000 database (included) and I have included an executable.

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.

Asynchronous Database Processing via Active EXE - When processing thousands of requests for a multi-user real-time application, you cannot afford to wait for the relatively slow database processing to occur. Here's the scenario: You have 1000 people already online and playing your multi-user game, and 10 people in the process of logging on right now. What do you do? You could process the logons right now, searching through thousands of user records, to load up their information - but then the game would appear to 'hang' for everyone already playing, waaaay bogus. You could process only 1 person at a time, in the main processing loop - that's better, but will add unnecessary slowdown to your program. What if you could log on the person in a BACKGROUND process, which wouldn't slow down the existing users? Ooh yeah. Or better yet, hand the request off to a machine across the network, dedicated to database processing? NOW we're talking! :-) You can do this easily, using Visual Basic ActiveX EXE's. Have fun with it!

This code allows you to connect to a SQL Server database without creating an ODBC Connection.

This project uses ADO to copy tables from one Access database to another. I did this up as a demo of ADO at work. It (probably) has no actual use but demonstrates ADO connection. This is my first submission, so please, Be Gentle!

Have you ever needed to view a database on a computer without MS Access? Here's an alternative. It uses ADO 2.1 to open, view & edit MS Access, SQL server, DSN and Oracle databases. There are also a few features to let you add, rename and delete tables as well as purge based on a Date/Time field. Clearly not a replacement for MS Access, but you can distribute it to help troubleshoot. Automatically registers itself as the default database viewer for .mdb files on systems without a default already set. Otherwise, it becomes a second option when right-clicking. Its Biggest advantage is its all ADO. No DAO at all. Now you're able to modify older versions of Access databases when Access itself requires a conversion!! I recommend distributing MDAC 2.5 even if you have a 2.1 application. Microsoft seems to have fixed some of the install problems with the MDAC 2.1. Please Note that you MUST HAVE the Oracle client installed on your PC to use the Oracle connection!!http://www.microsoft.com/data/download.htm ** Updated 3/21/2000 **Added Password support for Access databases.Please vote!

This will allow you to get BMPs (only Bitmaps) from an Access database using ADO. Officially, Microsoft says this about it in MSDN:INFO: Issues Migrating from DAO/Jet to ADO/Jet ID: Q225048 OLE Container Control Many databases, including the SQL Server 7 Northwind database, contain pictures and other objects saved by Microsoft Access. In Visual Basic, you can see the pictures by binding the OLE Container control to the DAO Data control. However, the OLE Container control is not compatible with the ADO Data control and there is no way to access these pictures and display them using ADO. The OLE Container control cannot be used unbound because GetChunk does not retrieve the data in a format compatible with the ReadFromFile method. Please Vote!

select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.

This code will create a database and produce a document that contains all of the table and field parameters. This is the first part of a series that will show how to use a single program to dynamically deliver any type of interactive multimedia courseware whether it's Computer Based Training(CBT), Computer Assisted Instruction(CAI), or an Adaptive Evaluation and Examination System(AEES) with all of the information being read from a database.

Basically I took the most common database commands and wrapped them into an Active X DLL. Step 1 – Compile the DLL Step 2 – Open and run the “Test” program Hope this helps some of you newbies

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.

My third submission to Planet Source Code demonstrates how to use ADO and the Datagrid Control together. One neat feature of this app is the use of a horizontal scroll bar to move through records. I haven't thoroughly tested this app so don't be surprised if you find a couple bugs. If you're new to ADO or even a novice I'm sure you'll find something useful in this app. Please vote and give me some feedback!

Have you ever wanted data to be returned a page at a time? For example the data you requested returns 200 rows and you want to return them to the user 1 page at a time? Well now you can! PS!! Do not forget to rate this software. This results in more code!! Thanks.

This class will let you create ADO recordsets on the Fly - Without a database.Once I wrote a dll that had to return an ADO recordset, but as I had no connection to a database, I had to write this class and I felt like sharing it.This class will worl only under VB6

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