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

Some SQL Server actions: - create database - delete database - execute SQL command - execute SQL script

Updated ver 2.0. In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch update. This app shows you how. ADO data binding without Adodc control, database file creation, table creation, and combo box data listing and click to find a record is demonstrated. I appreciate your comments.

My code is a way to password protect a cd, so that only a certain user can access the setup program, it also allows the user to choose which one of the cd drives its in.

This is a family address book program created using VB6. Its main purpose is to store personal address book information for each member of a family. THIS IS AN UPDATED VERSION OF THE ONES THAT I CREATED SOME TIME AGO. THIS VERSION HAS ALOT MORE FEATURES SUCH AS PRINTINING / SEARCHING, Personal Internet Links ETC. IT ALSO USES THE LISTVIEW AND TRE VIEW CONTROL TO GIVE IT A BETTER INTERFACE. REQUIREMENTS Microsoft Windows Common Control 5.0(SP2) - COMCTL32.OCX Microsoft DAO 3.51 Object Library. Please write any question comment or suggestion. Tell me if you find any bugs. Note : Read the file readme.txt before you begin using it. If you are running the program for the first time you have to allow the program to Create the Database file. Filesize : 296KB. CHECK IT OUT!!!. Author : OmarSwan.

translate from english to : 1)french . ( 3257 words ) 2)german . ( 9600 words ) 3)spanish. ( 7487 words ) 4)italian . ( 5160 words ) 5)portogue . ( 1375 words ) very simple, very fast , searching from a txt file.

Complete repository for all of your code. Include attachments, web links, shortcuts to other apps, organize on user-defined categories, searchable database, want to keep track of who gave you feedack? No problem. Copy and paste into your project, extract routines from existing projects. Share database entries with its Import/Export function. Help file included. If you use this one, you won't need another.

Creates ADO Access 2000 Database

This code is used to convert entire Excel Workbooks to Access Databases. Each Excell Worksheet in the Workbook becomes a new Table in the new Access Database. This codes has a problem processing more than one file at a time without stopping and restarting the program. It looks as if it is processing the file but it never actually imports the next file's Worksheets. Try it and you will see what I mean. Any HELP would be appreciated.

I catalogue this program like an utilitiy this utility generate a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Version 1.1.0! Vote Please! Just copy and paste the code generated to new VB project and two references Microsoft ActiveX Data Objects 2.5 Library Microsoft ADO Ext. 2.5 for DDL an Security

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

This code takes an Access 2000 database and creates a VB 6 class. Greatly reduces the amount of time you spend creating classes based off of your databases!

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.

This little bit of code and table will help you manage tables with linked/split databases. Currently it only handles MDB or Access databases, but it would be a simple task to set it up to handle other types of tables. Basically, with this little code, you can Import a table from another DB, Export and then LINK to data from Current db to another db, or Link to external data in another Db all automatically just by setting the tables in the MOVETABLES table. I'm also going to add some features that will allow you to "upgrade" an external data table with a new Structure for those of you who make a new front end and also change the structure of the back end but you don't have access to the production version of the back end for whatever reason. Should be up sometime today.

This application discovers all about ADO Connection builder to help you Creating ADO Connection String to any databases or maybe use the codes to your project in simple way as 123.... Don't forget to vote me.....

Take the advantage of learning ADODB and the datagrid control in a MdiForm with the capability of doing; addnew, delete, edit and search... Thanks for using ...

This is an utilitary program. You can open an Access database (97 or 2000), and by selecting a table, the program lists the fields with its data properties. (Once more, I'm sorry about my english)

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 is in response to a 'Request for Code' in the discussion forum. It's similar to lots of other submissions of address book style apps. It shows how to create and access a database without any data controls - just by referencing 'Microsoft DAO 3.6 Object Library'. Purely an introduction to databases - nothing more. A simple address book in 160 lines of code, easily expanded, with lots of comments to guide a beginner through the code.

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 code will dynamically create an Insert SQL query for a database. It also teaches some things like how to create a database and table though code, how to use the ADOX library, data formatting and etc...just look at the code, to much to write. Requires ADO 2.5 and was created with VB6 SP4. Not tested on anything else. Reasonably good commenting, should be easy to understand.