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

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!

Digital Statistics Calculator saves all entered data to a DAO database and can send it to Excel for graphing. The lab where I work wanted this to avoid doing double data entry.

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.

A viewer and editor of a database with 10,000 computer acronyms.

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 47 - DbaMgr provides a graphic management interface for MS Msde 1.0 installations. 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: an alternative inexpensive console/management tool for Microsoft Sql Server 7.0/Msde 1.0. 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. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.5 installed, as long as SqlServer Client Components (Sql-DMO). SqlServer 2000/Msde2000 version available too

DbaMgr2k provides a graphic management interface for MS Msde 2000 installations. 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: an alternative inexpensive console/management tool for Microsoft Sql Server 2000/Msde 2000. In addition to traditional Sql Server objects management and permissions, DbaMgr2k adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation, extended objects properties support. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.6 installed, as long as SqlServer 2000 Client Components (Sql-DMO). SqlServer 7.0/Msde1.0 version available too

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().

I saw the earier example of a global error handler written in C#, but needed it written in VB for my company. I translated the earlier work into my version in VB. It was suggested by a couple of people that I provide my VB version, so here it is. I just hope you find it useful. You can visit the C# version at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=948&lngWId=10 It was submitted by Joel Thoms on 2/5/2003. Thanks to all that asked me to post the VB version. Special thanks to Charles Richardson for helping me track down a bug. When you paste the code into the IDE, most of the formatting should return.

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