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

Exports an ADO recordset to Microsoft Excel.

I have worked out all the bugs in this realse, I changed the UI a little but it's still the great looking employee database. PLEASE RATE IT IF YOU LIKE IT . Any comments are welcome. The User Name and Password is "admin"

This is an excellent database program the screen shot speaks for itself has a lot off features. Basicly for storing and keeping track of employees. "PLEASE RATE IT IF YOU LIKE IT" it also has a custom CD Player built in. I will be uploading version 2.0 in 1 week so keep an eye out for it cause if you like this you'll love version 2.0. Still a littly buggy but it's still in its beta stage. Thanks PSC

To show how to get table name and query name using ADO . This code also shows the connectivity with EXCEL

The code demonstrate the use of ADOX (Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security). This will be a series of sample codes that will demonstrate the use of ADOX. For this sample the code will access an mdb file and display its tables and related fields in the listbox. Also supports password protected mdb file.

A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.

Please check it out. It is a good tool.

To generate Payslips

update from my previus posting. This my sample code how to manipulate Datareport without using DataEnvironment this sample included datashape concept and how to link image dynamicly.

vb6 Form.show method in vb.net

A very fast way to fill or populate a MSFlexGrid control with a Recordset 18,000 Records / 2 Sec.

Automatically generate a function to create an Access 2000 Database With ADO. I catalogue this program like a utility. This utility generates a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Verion 1.1.0!

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

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

ADO Helper 2.0 now includes example projects to demonstrate the working of ADO. This will help to directly use the codes in application. Example projects include: Demonstrates how to use Cross Tab, How to handle ADO Errors, ADO Find and Seek Methods, How to use ADO with Grid Controls, Use ADO with Data Report to create Simple Data Report, A complete ADO Unbound example to show, add, edit, save, delete with navigation with error handling, How to practically handle ADO transactions. These example programs will definitely help beginners and pros alike. With the passage of time, ADO Helper will become the complete source of ADO Help and Example programs at one place. Coming soon are topics such as: Data Consumers, Data Shaping, ADO MD to summarize data, Creating Data Sources, A complete payment management system using ADO and crystal report.

Allows you to automatically generate column headers and load all the records from a table or SQL statement into a listview.

These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.

My Address Book(AnyAddress) allows you to add the persons name, email,Homepage ,Address, phone number and so many other fields. It also have good GUI. It is fully User friendly So u can easily use it. I have used Microsoft Access as Database Sql for searching the records.

MS Access developers will be amazed at this solution. Smart form requires zero programming on your part. What if you could intercept the MS Access sql statement before any database transaction occurred and record this statement in a journal, would this be valuable to you? Of course it would. What if you could replay the journal DML entries in the event a database crash occurred, would this be of value? If you haven’t solved the transaction problem you’ll love this article. Spread the word through the news groups.

Need to do any oracle/ADO work? I wrote these to help me along in my projects. I hope you find them useful too.