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

If you're ever wondering what's contained in a recordset you currently have open, here's a quick and dirty way to dump all the data you could want to the Immediate window, which you can view there, or copy and paste into a notepad document or other textfile for printing, etc. I like to keep this somewhere I can quickly copy and paste it into any module or routine that uses a recordset in case I lose track of which field is which. (I've only tried this with VB 6.0 and AO 2.6, but I imagine it would work with other versions.) --Brian Battles WS1O Middletown, CT USA

This application can Extract the existing DAta structure of any SQL Server database and it can be saved in HTML table format.Tables structure of selective tables can be Printed.Table can be taken copy

with this procedure we can handle the queries or stored procedures which returns multiple recordsets - through ADO's

This function retrieves data from MSHFlex Grid and prints it directly to the printer. It determines whether the information should be printed landscape or portrait.

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!

Well, I was trying to make a address book and I couldent think on an interface. So I thought for like 1 hour and I made one and I decided for thoes people out their that want to make an address book, that they could you my interface! If you use this please give me credit and you can re-arranfge it, and do aything to it!

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!

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool

This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.

I work with Access databases, and occasionally will need to update the front end on the server. With access, you can tell when all users are out when the ldb file is missing. Therefore I created this app that checks for that ldb file. When the file is missing it uploads a specified file to the specified directory. This works excellent for me so that I can update files when all users are out. Hope this is helpful to you. Feel free to add/change or make suggestions.

This program demonstrates how you can take a table from a database (MS Access only in this demo) and convert all the records in that table into an HTML document for viewing in a web browser. With very little effort, you can add more HTML tags, more records, etc to have a really nice looking web page. I'm working on one that will use SQL statements to get certain information, instead of the whole thing. The code is well commented, and any questions can be directed to me

This application was written with the intent to serve as an example of how to use the MSChart control that is shipped with Visual Basic. I've found out, the hard way, that the documentation for Microsoft's chart control is poorly written, if not totally useless! This example might be silly but I garantee that it will help you understand how to manipulate and create graphs, specially for those who work with scientific data (like me).

This project uses ADO connection and recordset to get the sales from an Access Database. The data is then presented in a Chart with the sales grouped by days of the week. The display is in spanish, when you read the code you will know what Lunes, martes, etc. is. Hope it will be of use to some of you.

This is an updated version of a previous project, to demonstrate the use of a MSChart control with ADO to show scientific data. Some other tricks are shown... A newer version will be coming out very soon to teach DML with ADO.

Save binary objects to a DAO database, eg: pictures, exe files, dll's etz. Its a generic class module that allows saving/extracting from any access database. Also gets additional fileds if required for example a persons name if it was stored in the same table

It can parser simple XML like file and read/write data in it. Gives simple access like any Database.

Perform All Database Operation Using Object.

This is an advanced autocomplete function that will autocomplete for a textbox, a listview control or a listbox all from 1 function. I have seen code on this site before that had inspired me to create this function since I need it in a lot of my projects. I tried to comment everything as well as I could. if you have any questions email me and I will do my best to help you. oh yeah - Please vote for me if you like this code. thanks

This is a basic example of how to use an access database in an application.. an address book... It has options like search, add, delete, view all.. again, just an example