Results for "Category: Databases/ Data Access/ DAO/ ADO"
For beginners to understand how to use the MSHFlexgrid... My code will populate records from a database to a MSHFlexgrid...
Database Application
An easy approach to saving images to database , displaying them, even save to file and search and display relevant images from database.
This is an example of connect to a remote My SQL DB hosted at Lycos WHITOUT an open remote port, using a PHP Tunnel hosted there. This is the first and incomplete version of a future Query analizer. PLEASE VOTE
This code is just a simple attractive user validation... using msaccess database.Now you can add this to your project very easily.
Encrypt and decrypt ms access(*.mdb)
This is just a very basic beginner's tutorial for using ADO to connect to a database. Trust me, there are more comments than code! Please leave comments, as they help me grow! I won't beg for votes, but they also help me grow. I'd like to create more database tutorials, but need to know how to improve for future versions.
I needed to modify a database and add a new field to it. I couldn't find anything here that just did that, so I created it. This uses no active-x. Also I used a lot of code from a program called Database Tutorial v1.0 written by Dustin Davis, which I found here on PSC and I did give credit within the file. I also gave it the ability to create a new database in 2000 format. I would like to hear any suggestions.
It's easy to generate a CSV file with any delimiter by using this class module. Hope useful to anyone.
This is a updated version that was wrote by Chad Gutowsky. He ask if someone could create one listview to show instead of three. I thought this is a perfect program for network users.
This is a good example of access database, for beginners, add, edit, add UserNames to list box and browse trough it. Very simple to understand.
A simple management information system. comments or suggestion contact @: cell_nor@yahoo.com Mobile#:639212733741
add, edit, delete, print payslip comments or suggestion please email @: cell_nor@yahoo.com.
It is a complete library system, add, edit, delete patrons, administrator and books, it is a complete package and 100% working
This application allows you to quickly build an industrial strength database program, and adds many safeguards and features that you would otherwise have to code for yourself. The app accepts database schema definitions in the form of an XML file and generates all of the code necessary to access SQL databases in the form of a VB module that you insert into your application. Operations that are performed for you include the following: * Handles all of the issues related to initialization strings and opening the database(s). * Generates correctly formatted SQL statements for both queries and updates (errors are caught at generation time rather than when the code is run). You can rerun the generator at any time when the schema changes, and the code will then always be correct. * Handles SQL error recovery, display, and logging of errors automatically. * Deals with many SQL gotchas, such as escaping string field values containing single quote chatacters, handling maximum text field lengths, date field formatting for queries and inserts, verifying numeric field values, recovery from null field errors, etc. * Resolves many of the subtle issues related to differences between various SQL systems (MySQL, Oracle, Access, Postgres, etc.) * Provides a very easy-to-use programming interface to the SQL system. The logic handles many database programming situations such as multiple database connections, multiple table buffers, using SQL DML v.s. recordset operations, defining the system to generate only the desired type of access for each table, etc. The generated code can also be used for VBA applications. This system has been in operation for a number of years, and therefore is very solid and well-tested. Full documentation and a sample is also included.
This code will bind any recordset to listview, this is a function i made... im looking for any similar code for this and i cant find short code so i made one myself.I think this one of the shortest code to bind any record to any listview so you wont code any.
This is my first program i made in VB 6.0. This simple program is for the beginners in VB like me. This system can add, edit, delete, output reports and etc. Please vote this little system. Thank you and God Bless... The above screen shot I used third party button but this I changed the buttons into a basic because server from this site deleted the file for the third party when i uploaded this program. But the environment is the same except the buttons. -Roy Villafuerte Naparan
for soving datareport problems and graphics splash, i am going to share some codes. Note:The following documentation is GREATLY appreciated by your end users and will affect their judging of your entry.
This is a complete "3d Drug Store POS". Don't be confuse with the word 3D, it's the name of the store (3D Drug Store).I use ADO, Access for the database and crystal report. It has 3 users namely: admin, cashier and clerk. It has a reorder level feature that can monitor products that needs to be order, it can monitor expiration and warranty date, and lot more
Check Book System: <:- Freeware -:> Check Book system allow you to record all check transaction within your organization. It covers Recoding of expenses, Monitoring of Checking Account , Printing or Check Voucher, Printing of Summary Report, Recording of References (Vendor and Expenses Account), and Inquiry.