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

Everyone knows, that VB's reports can only make static reports... And what can we do to make report from dynamically selected data? Here is the answer: we only need to use HTML Reports - easy and powerful solution for creating HTML-based reports. This is the initial version, I think, that some improvements can be implemented in the future... Please leave your suggestions, comments AND VOTES :-) Thx.

A nice student database with a very user-friendly environment.

A database application that allows you to connect into two drivers: MS Access, and MySQL Server. It has instructions on how to create the database in MySQL Server. Uses ADODB and SQL statements. Has nice GUI too.

This inventory system for tires include: Administrator Password, User Account, Tire Maintenance with Category, Tire Size and Tread Pattern Data Entry and Data Report, Customer Maintenance with Data Report, Sales Invoice with Receipt, Printable Monthly Earnings and Order Slip Form with Supplier Data Entry. Made with ADO. 100% working and bug free. *Administrator password is "DBMS".

The code uses the Microsoft Access security utility that sets database password by which the program is only the one who can access the database. It also allows you to create and delete an account by having a "USER LEVEL" and a "ADMINISTRATOR LEVEL" feature. To summarize up this code helps you to add a security form to your application...generally looks like WINDOWS logon...

PURPOSE OF THIS PROGRAM IS TO GENERATE PAYROLL BASED ON INDIAN HR SYSTEM INCLUDING ESI,EPF etc. YOU MUST HAVE LITTLE KNOWLEDGE OF ORACLE TO RUN THIS PROGRAM SUCCESSFULLY OR JUST FOLLOW THE INSTRUCTION AS GIVEN IN README.TXT FILE. !!!! YOUR VALUABLE VOTE REQUIRED TO ENCOURAGE IN FUTURE !!!!

Shows how to use INI files as highly flexible,huge databases!!

This little utility allows the user to select an Access database and then generates the code to make a connection. It also allows the user to select a table from the database which then generates a simple SQL. Also attached are instructions for use and a test program If there is sufficient interest I will continue to develope code writing programs and submit them to PlanetSourceCode. Although a few votes would be nice I am more interested in feedback. Taken from an idea by Carlos Vara, thanks.

I had problems using the datagrid attached to an ADOdc control. Here is what I found.

This is a Report program desiged for an export corporation. It Uses ADO. You can add, edit, sort, search and print(with printpreview). Additionly you can set autobackup for defined times and can add logon feature, systemtray icon and more...

1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool

Good for beginners who want to learn database. I include simple code in searching,add,edit,delete,print in the system. It has good GUI.JUST TRY!!!

READ THIS° : Do you have so many Source Codes and don't know how to arrange them?. Well, here is the answer to all your problems. The Ultimate Source Code Storage Database utility has come atlast. The program contains whole new features where users can EASILY STORE: CODE NAMES, AUTHOR NAMES, DESRIPTION( Read Me's), PLATFORM, PROJECT LOCATIONS, ZIP FILE LOCATIONS (Backup Locations), RATINGS, DOWNLOAD LOCATIONS, DOWNLOAD DATES, CATEGORIES,COMMENTS and whole lot more. The Code contains BUILT IN advanced SEARCH PROGRAM where users can easily search their code in the Database. Have a look at SCREENSHOT. Users don't have to worry about Zip files that come in unique names, just mention the Zip Location of the code in this program and program will do the rest- by storing the Zip file location in the database. You can EASILY OPEN- Projects, Zip Files, and Screenshots. In the same way you can store author name, readme's, Voting locations, download dates, comments, personal ratings and lotZ more. This program uses a eye catching Visual Styles with Windows Xp like interface. If you want to Print- then this programs ADVANCED PRINT facilty is just for you. This code is optimised for Planet source code users but you can twist it the way you want. This code also contains Easy to Use ADD ENTRY FORM where users can easily add their code and their details to the DATABASE. You will never know How this utility may come in handy for you, until you download the Code. Perviously i was using this utility for my personal use and this time its for you with a bunch of New ADVANCED FEATURES. Please DON'T FORGET TO VOTE FOR ME. Add this code to the Database first.°!!!°

This is a Password Program. does what the Windows 98/95 Password screen does. But the program cover's the whole screen. It shows how to use Database... And find the computer's Username...

This code will blaze through creating even the longest SQL statements(Jet supports up to 64K). This is an updated version of the SQLHelper post I made about six or so months ago, with various optimizations made since then. I have found it to be very useful, hopefully you can too! All code was written by me and is free for all purposes with the exception of cStringBuilder.cls, which is from vbaccelerator.com.

A vb test application which opens queries from access instead of tables for a datareport.I could not individually open selected records so i made this instead.

to easyly find edit and store unlimited phone numbers

Rick's codebank is a simple application which, I believe, would be a good learning tool for beginners. When I was first starting out with VB it was nearly impossible to find a complete working project to learn from. Books and manuals talk all around a subject but never really show you how to do anything practical. They give you a few snippets of code, but never a project complete enough to give you the big picture.

This source code permits to connect to a DSN ODBC connection on a remote computer running dbTCP. THis can be very useful if ODBC licences are very expensive (I had the case).

This is an Access mdb (in Access 2000 format) that searches a directory path for all mdbs with linked tables. There is a two-step process: 1) After selecting the search path, the code searches through all subdirectories building a collection of found mdbs. 2) The collection of found files is opened and each table in the mdb's TableDef collection (yes, this uses DAO, not ADO) is checked for the Connect property. If a value is found, it is added to the list box. In the event there is an error (the mdb cannot be opened, the version is incompatible, etc), the error is noted and the file can be checked later.