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

This sample program is just used to show you how to load the entire Database into MSFlexGrid using ADO and SQL command.You can view and search all country Code by just a click.

Compact Access Databases with one line of Code! "One line of Code", like this: ;-) CompactDB Database, ShowResume, Password or this example: CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" Private Sub CompactDB_Click() If DB Is Nothing Then 'the database is Closed CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact Else 'the database is open DB.Close 'close CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact [Call your Routine to load database] 'Open database End If End Sub Works fine with Access 2000 and XP Actual Revision - Jan/20/2004 Jan/20/2004 · some Form changes. · fixed some variables declarations. (Variants in place of Strings). · added Compact Password protected databases. · added some Comments. · added some Code examples. · added a compress level indicator. Jul/25/2003 · Initial Release

A simple example on how to add/Delete a DSN to the ODBC of a Windows Operating system. Completely commented.

Application to access Adaptive Server Anywhere databases. Uses CMAX OCX (http://www.compiled.org/files/115/259/cmax20.ocx). Uses RDO for data access. All other components are standard VB components. Help File not included because of licensing restrictions. Sub Main is in sqltool.bas. SQLAny.bas has data logic in it, and could be modified for other databases.

A complete Medical Store Retail Management System. Sales & Inventory Control. Stock Monitoring with expiry dates etc...

This is a code that i just add some lines because the original code not create index, primary key, etc.

Version 1.5 of award winning Wolf DataGrid, fully working data grid now with many new features.

If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then you are gonna love this ;). This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source (though not for proper distribution for now). Have a look at screenshots if there are some (psc might not allow me to upload them). There are some examples included on how to use the grid. It does not matter what drivers are used since this grid uses t-sql for reading/writing data. For now it does not support built-in editors, but that is to be added in next version. Just download the example and experiment a bit. If you need any help on using the control post comment here and I will be glad to help. This is first version, so please post any bugs you may find.

It loads the present records to the inside with a Database in a ListView with ADO and through SQL it is possible to load the records, it includes also the ordering of the columns in ascending way or descending with the icon that it indicates the type of ordering. Finally the present records in the ListVIew are possible to print through 2 selections all or the records select to you through checkbox. Code is full commented! PLeaSe VoTe FoR Me!!!

MyVbQL is a Visual Basic API for accessing MySQL databases. This API was developed as an alternative to the MS ADO - MyODBC interface that VB developers must use for MySQL database connectivity. For more information, visit http://www.icarz.com/mysql/

Want to work with MSACCESS database? This code is for you. You can perform add, update, delete and searching operations on database. Best part is the searching.UPDATED WITH FULL HTML HELP ON 9th Oct. 2002.How to write to registry is also explained with full error handling.Please vote for me....

Cant remember the important things in your busy schedule? Then have this code (Using MS Access Database). This code reminds you on the date and time set by you by a popup window which will be on top of all running applications. Prpoerly commented. You can reschedule the reminders. Can mark them as pending a or done. At start up checks all the reminders which are not shown previously bcoz this application was not running at that time.when you close it (by X) then it will be in the system tray.Dont forget to vote for me.

This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.

This is my first post on PSC and it happens to be my biggest program ever attempted. It is not really clossed to finished but it proves that it can be done, it is a fully functional DBMS made in VB, this includes SQL queries, multiple tables, unlimited columns, validation rules, editing feild properties. This program is not yet in beta stage, with large amounts of work to be done. I am posting this to get feedback from other people on things I could add to make the program much better or change to give it more functianality. All comments are welcome. My main reason for posting this is that a few days ago the VB code of the day was a table so called DB creater, but could only take one table. There is a lot of string manipulation in this with the DB save in a plain text file (yes I know that could become corupted easily, i am going to work on measures to prevent that and solve coruptions) In certian sections the program is fairly well documented but in others not, thats something I need to do soon. Well please give me any feedback or even test the system out, included in the ZIP is an example DB called Test.bvd you can load this and mess around with it, delete records, do SQL queries, add records, export as XML and all, some of the functions in the menu do not exist but are there to remind me of what is to come :P If you wish to vote for this do so, but as I said the program is not finished, it is more a proof of concept to show others that it is plausible. Its around 4K lines and will probably be 10K by the time it nears finish time. Jonothan Tompson

This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.

This piece of code shows how to connect to mySQL database using Visual Basic, myODBC 3.51 and DAO 3.5. It is very simple for understanding and code is commented. If you think that code is very helpful, you can vote for me.

Connecting to MySQL 4.0.2 using myODBC 3.5 & ADO 2.7 without creating DSN in ODBC DataSources in ControlPanel. In this sample is a code for adding records, showing records in listview removing selected records from list, searching records (you can search for records by name or by surname or both. Inside code is description what you must do before running code.

This is a Sales and Inventory created in Visual Basic 5 for the fulfillment of the BSCS course in Asian College of Technology in Cebu City, Philippines. It is originally programmed by Jerson Chy(super programmer) and was re-designed by Ted Antonio(computer hacker). Hope to receive messages on this system..It is complete and very useful and it can even be sold to anyone who wants it...Happy selling this product

This is very simple address book keeping data for your nearest one and also getting alerts for the reminders of the birthdays.Please Vote for me if you think I did good job.

Well.. for those who where happy about the previous version, heres a little update with scripting for Views, StoredProcs and missing tables. Works like a tierelier (Dutch ;-)). For those who don't know about the previous version, it compares 2 SQL-server databases. Also if somebody doesn't know how to implement a splitter, here's a idea how to do that :-).