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

This code will import textfiles into a MS Access database using different kind of seperators. A MUST SEE CODE! It works great and can be used for a lot of things!

Reportgenerator similar to crystal reports or list and label. at the moment, it´s documented in german. it uses dao to print reports out of access-databases (either with or without print-preview). it should be no problem to migrate to ado to get access to any type of databases.

A simply utility to search US postal database. You can search by city, state, areacode, zipcode, or county.

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 generate Payslips

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.

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.

This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

Complete Library Management Software fully commented,No dirty coding. Very useful for beginners!!!!!! Please vote

Create Shape Statement For Master/Detail Form In Visual Basic.I Made This "Generator" Because I Couldn't Remember The SHAPE Statement And Now I Publish It For All Developers Who Cannot Remember It And It Is A Good Example Of ADOX And ADO.The New Version Is With Full Test Of SHAPE Statement.

This code is an ADO modification to the previous post from Robert Row in December of 2000. This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record in an Access 2000 database that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

Treeview Database sorry it is in German and my first Submission. If you like it I will put it up again in English.

Ado Database which stores Usernames, Passwords, Notes. Passwords are kept encrypted. For the Encryption i used the DS2 Class I found on this site.(Author: David Greenwood)So far the best Encryption - Example I could find here. Uses the Microsoft-Style of Ado Database. Features Add, Update, Delete, Cancel, Edit and a Listbox. See Screenshot!

to all programmer out there who is like me...download code and don't know how to manage it.. :) this simple program shows and help us (maybe..)to manage code/program/module...u can modified it as u like...i'm new in this area..i'll be glad to have some comment(s) from u to help my programming skills...c ya..

This code takes a user specified Access Database (I used Access 2000) and prints the database structure to a printer or to an HTML file. Currently working on adding Queries, etc. to the mix as well (Version 2.0!!) if i get any feedback.