Results for "Category: Databases/ Data Access/ DAO/ ADO"
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.
This sample project will show you how to easily structure a query to a DataBase. The sample uses the NWND.MDB that ship by default with VB5 and 6 and demonstrates on a searchform how to search on a text from a textBox and use the different comparison operators like =,>,LIKE, etc. NOTE: This is for total newbies that have a hard time figuring this out. I myself had a hardtime in the doc to get an easy explanation on this. Cheers, and hope you enjoy.
This program converts any SQL Server table into a CSV text file.
Imports ASCII text databases in any format, to Microsoft Access format. Very nice GUI. You will need to find a "Replace" function from Planet Source Code and paste it in... only if you are using VB4 or VB5.
What you can do is hook up to a database, and with the use of a timer control, you can make a list of any/all records you want in a database. You can use an SQL statement (in the code already) to find a certain part of a string. The return results are any record that contains that particular string in it. Then with the click of a button it will go through each record found and make a list of them. For example, For a spell checker, I took a database that contained over 5,500 words. It went through that database in a little over 5 minutes to get every word made into a list. Very good ideas can come from this, have fun with it!
This code is an update of my previous submission. I put in code to convert database info to a comma delimited file, and to fill a listbox with data. I'm still working on it to do more things (SQL searches, etc.), and I'm going to do images,and things like that. I'm also going to improve the conversion to HTML to make it even better. Have fun with it!
Complete wholesale product inventory database program. Combines Access, DAO, and Excel to manage inventory, write reports, and print forms. I wrote this for work so you might as well have the code.
Have you ever try so send a SQL String to a database that has apostrophes ? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database
Update: ver 44 - DbaMgr provides a graphic management interface for MS Msde 1.0. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility. In addition to traditional Sql Server objects management and permissions, DbaMgr adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation. (468 kb)
This code can literally do anything you wish with an INI file. Here are a list of the 21 INI functions that I created. These took me a long time to make, so please let me know what you think. A program is included that explains everything completely...from how to use the functions...to an explanation of each variable. GetKeyVal(), AddToINI(), DeleteSection(), DeleteKey(), DeleteKeyValue(), TotalSections(), TotalKeys(), NumKeys()-"To count how many keys in 1 section"-RenameSection(), RenameKey(), GetKey(), GetKey2(), GetSection(), IsKey(), IsSection(), KeyExists(), KeyExists2(), SectionExists(), GetSectionIndex(), GetKeyIndex(), GetKeyIndex2().
**** Access97 Descripton Program !! ****
Returns instant record count, structure of DBF files
This is a demonstration to show you how Header Tables relate with Detail Tables. Don't forget to vote for it.
Im sick and tired of using a third party report generator such as Crystal Reports, etc. so what i did was i mastered Data Report of Visual Basic 6 and here is sample of how to print an image to Data Report using ADO Connections. I hope you like this sample of mine.
This uses a Microsoft Hierarchical Flexgrid Control 6.0 which is an OCX control of your VB6. This demonstrates on how to relate different kinds of SQL using ADO. This provides tutorial to all. Don't forget to vote for it.
Don't miss this guys coz' this is a corporate code that i developed before using ADO with complete Login Entry,Masterfiles,Transactions such as Sales Order, Purchase Order,Receiving Order, Reports such as Inventory Report,Sales Report,Critical Report and Backup/Restore/Password Security features. Using this example you can learn a lot about how ADO really works without using any data controls. This is the best contribution of mine in PSC so far so you better not miss this coz' this code really rocks. PLEASE DON'T FORGET TO VOTE FOR THIS CODE COZ' THIS CODE REALLY ROCKS!!!
This is a complete application, cash register & inventory program/point-of-sales monitoring that is customized for a drug store/pharmaceutical company. It has many capabilities such as: Login Security, Selling Transaction, Receiving Transaction, Multiple reports using Crystal Reports Version 7, etc. and much of all a "Cool GUI Skin from Mac Skin". This will be the best ever and the most complete application in P.S.C. This is very easy to learn. PLEASE DON'T FORGET TO VOTE FOR IT.
Stored Procedure Generator for SQL Server 7.0
This code allows for multiple record updates to be grouped into a single batch style transaction. You can then either committ changes to multiple records, or rollback the changes in the case of errors or conditions not being meet. This code is ideal for month-end processing, or in a situation where there is the possibility of errors being generated.
THIS CODE IS NOT THE SAME AS THE AUTO_COMPLETE FEATURES FOR VB5 LISTBOXES AND COMBOBOXES. This code is a class-module that enables VB6 DataCombo controls to function like MS Access combo-boxes. It adds an auto complete feature whereby when the user begins to type text in the combo it automatically searches through the list and completes the entry