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

Fix Apostrophe in strings for SQL query

**** Access97 Descripton Program !! ****

Corrects for reserved SQL characters in SQL queries. This will correct your SQL statement if an apostrophe or 'pipe' character is in the SQL query. It is a better fix than the SQL functions which replace ' with '' because those will actually still fail in certain situations (such as in FindFirst commands).

This is a demonstration to show you how Header Tables relate with Detail Tables. Don't forget to vote for it.

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.

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!!!

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.

Stored Procedure Generator for SQL Server 7.0

It is a great visual tutorial to learn about Databases in Visual Basic. This is the part I because i couldn't upload the zip file. Please download part II at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44042&lngWId=1. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

Please download part I at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44040&lngWId=1. I'm sorry but i can't load the zip file in one. It is a great visual tutorial to learn about Databases in Visual Basic. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

This is a small collection of ADO Examples I made some time back. it was ment to be as a small tutor. but I never finsihed it. so I thought I may as well let you people have them. mostly for a Beginner, starts of by makeing a simple connection, to viewing, adding and editing data, and also some tools, such as Compact and Createing a new database and adding a new table. All examples are also commented, and are in seperate folder. Hope this may help some beginners out.

Hi this is a small tool I made to makeing Databases in VB with out a Access, you can add tables, fields, types, you can also add, edit and delete records this is only the first version so I hope you like it.

Hi this is a little VB Code Collector I made for my self to store all my codes, You can Add, Rename and Delete Categories, Add, Edit and Delete Code examples, You can also compact the database, New Update include a quick serach of cocdes and now codes can be stored in to sub Categories, hope you like the update

Hi, this is a small example of using DAO to view a database without access, it very basic and should be handy for a beginner shows how to get all the tables and load them into a Listview, anyway I hope you may find some use of the code.

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.

Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.

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

if mdb_dsn_connection doesn't exist... then make it

To upload and retrieve ORACLE BLOB File using ADO Recordset. Never try with other than ORACLE database, but i think i can ...