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

This article explains how to, using pure code, without having to reference Excel, Access, dBase libraries, etc, export data from one format to another.

Example for data validation, database and data manipulation. If you like to see implementation for Search and Filter than take a look at ABCStores_02. Please vote.

How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)

This code demonstrates how to use a connectionless recordset.

The purpose of the following code is to demonstrate how you can load a datagrid with data from a text file.

Demonstrates many common VB controls, ADO databound controls, Datagrid, and input validation in a VHS movies library. Hopefully demonstrates good code style.

This demonstrates how to create a database and components at runtime from a public sub called from the AdoxData class with ADOX 2.1 objects

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

This simple database will save all your books collection, it shows the use of ADO, DataReport and DataEnvironment, it shows how to Add, Save, Edit, Delete, View Reports. Other cool stuff it contains a toolbar and a file menu. It also shows the enable and disable functions.

This source code was originally to predict lightning strikes. This source code is run in MATLAB and can be modified for different no of inputs. Meaning, this source code can be used for any kind of prediction!

Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste". For database browsing I used an API call: GetOpenFileName Lib "comdlg32.dll" instead of bulky CommonDialog Control. For getting a tablenames of the database I used OpenSchema(adSchemaTables)for create Connection and then simply added tablenames into Combobox. Then I used File access VB feature to write an XML file from access table, reading column names and columns, converting it into XML format and writing on disk. The last feature this program has to print out a newly created XML file into Textbox for analysis and, if necessary, "copy-and-paste".

2 functions to convert a 38 character GUID eg. {2E1EFAD8-4AD9-48A6-B9A9-75505F2B9A51} to a compact/compressed 16 character VB String eg. @#$%

Enables any user that can login to a database to monitor sybase activities. You can monitor your SQL transactions, functionalityy accdate, audflags,dbname,fullname,language,name,password,pwdate,resultlimit,spacelimit,srvname,status,suid,timelimit,totcpu,totio,affinity,blocked,cmd,cpu,dbid and much much more

This is a database application. It stores information for keeping track of company inventory. The database is empty, so you will have to populate it yourself

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

ADO Recordset Paging in VISUAL BASIC !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)

This is a Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.