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

A perfect example of using an Access database. With these example, you can add, delete, moving in the database. All validation is done. Use PageUp and PageDown to seek records. Very nice interface. Reusable code. All code is commented. Simply the best example ever on planet-source code about database management.

The prodram look just like Access, so don't be mistaken. IF you won to learn how to work with databases- the answer is Quarantine DB. The program uses ADO and DAO. With QuarantineDB you can work with, create, delete, rename tables and queries, add, delete, update records. You'll learn how to work with MDI form. Just try it and don't forget to VOTE FOR ME. e-mail : kicheto@goatrance.com

Search data in a database depending of what you write in the textbox, if you press the "M" key in the textbox you will get all the data that begins with "M", VOTE FOR ME !!

Version 1.0.13: added some error handlign. NEW! Added functionality: now it works also with password protected access databases. Update your new database from your old database at amazing speed. The program updates all the tables from the old database to the new one. If you find anything faster than this please let us know. Enjoy

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.

Using ADO: This is a demonstration of how one can take selected items at runtime from a user, create a parameter query using the selected items and then run the parameter query.

I used this class for well over 2 years. It is easy. It comes with a simple program that show you how to use it. I am sure that once you will know how it is working that you will adopt it.

To handle multi-users / concurrency of a MDB using eith DAO or ADO in the VB 6.0

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

Here are two functions that will allow you to read and write a Large Binary Object (BLOB) to and from a database. This could be used to store and retrieve images, documents, etc inside the database it self. This is great for those of use that have a lot of Binary files around that we want to keep in a central place that can be backed up and protected with the same security that a database offers. This code will work with *ANY* database that ADO can connect to.

VBRSGen is a handy VB 6.0 Add-In that creates formatted ADO/DAO recordset and SQL code from Access database tables and queries. Generates variables, sets objects, etc. Also includes a simple "Where" clause creator tool and a results preview grid. Code is ready to paste from the Clipboard or Notepad. Some SQL statements aren't parsed properly, but these can be easily edited; this still saves a lot of time in repetitive ADO/DAO database coding. I'm making this available elsewhere as shareware for $20, but because the PSC community has provided so much invaluable support and helpful code, feel free to download the open source code here for your own personal use at no charge! This was originally posted in early April 2002 and received amazing feedback and dozens of "5-Globe" votes, until the PSC database had some problems. So please vote and leave feedback to let me know what you think!

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

Thanks to Collin McAllister for the 7/13/1999 submission this is based on!! A visual adhoc query form that allows multiple criteria selections and simple joins. A simple (limited) somewhat user friendly way to create simple queries.

VB module to read and store ANY kind of picture file pictureboxes support into a database, it's easy and it's pretty fast... please, rate it, any comments are wellcome

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.

PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-) Well finally after heaps of emails complaining about the source safe protection HERE you go!! a non protected version, as you will see the code is a shocka, it really needs arrays. It reads everything off a text file to save HD Space. I am going to make an Access version prolly in about a month or so, well maybe longer coz i am doing my HSC. Anyway, this prog provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any! I DARE YA TO FIND A BUG!!!!!!!!!!!!!!!!!!!!!!

This was a piece of software i did for my HSC major assesment, 93% cheerin! Anyway, i have put a fair bit of work into it, it still has bugs, coz i only finished it the other day i haven't had a chance to fully de-bug it. There are also some changes I would like to make in the near future, but it is basically finish, so please enjoy, let me know what u think, and PLEASE vote high, i would love to win this months comp :-) The Admin Password and Teacher password are both "Gilroy"

Provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any!

With this application you can see how DAO works. You can completely control the database with this code, you learn how to read, insert and delete things from a database with no data controls or whatever :-) And also a great deal of the ListView control is used for this app. And it is completely documented and explained!!

Helps to maintain credit customers, with the details of bills and outstanding balance, etc. Useful for small companies, total solution. No need to purchase big software which has got too much unwanted functions for which you don't need to pay for. The code has got very useful stuff like managing ADO DB, creating reports, etc... hope you like the code and most of all the application. Most of the reported bugs are fixed (which were a few ui bugs). Check out now the update.