Results for "Category: Databases/ Data Access/ DAO/ ADO"
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"* VOTE OR DIE!
Updated!! Ado project now supports multi-user connections and is much more stable than ever before. if you have more than one connection open, the server now refreshes all clients connected when a new job has been created or modified. Server keeps a real time status of active and disconnected users, great great over vpn, or internet connection. ADO Project allows remote users to access a database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns
CompactAllMDBs is a Microsoft Access 2000/2002 (XP) application that will (1) Search for all specified files (default is .MDB and .MDA files) in a specified directory (and optionally, in all subdirectories below it) (2) Display all such files found in a listbox with their sizes (3) Compact all the files it found or only the ones selected from the list by the user (4) Search for the same files it found the first time and compare their size as compacted with their original size, to see how much disk space has been reclaimed It's handy to keep your ever-inflating MDB files of a manageable size, and it works nicely on networks. This can't really eb smoothly ported to MS Access 97 because it uses ENUMs in the code, which isn't supported by VBA in Office 97, to my understanding. Also included: (1) A simple routine for calculating and displaying elapsed time for the process down to milliseconds. (2) A "Browse For Folder" routine, based on a Windows API call (I originally wanted to make this start with a specified default folder, but I haven't had a chance to figure out how to do that yet) (3) Uses the Access (2000/2002) routine to Compact and ReCompile the application when it's closed down. In your VBA code, this application requires a Reference to MS DAO 3.6 library If you have any comments or questions, drop a note to brianb@battleszone.com
Binary Search Tree Nodes Class - an effective and very fast searching/database storage methodology. This is a self-contained binary tree class along with a non-gui listbox class to create, search and maintain any unique key data in a binary tree. A lot of databases use this methodology as the basis for their database engines. Now you can have the database power inside your application. For example, a search of 3,000 keys will only require an average of 7-11 tree visits/seeks regardless of the key your are trying to locate. Also included are member routines to output all the data keys in tree in alpha order or even in reverse alpha order. This has been extensively tested for reliabilty and fast response for searching, insertions, deletions and traversals of tree nodes in general. Included root node release, tree re-balancing and garbage threshold detection and collection. Also extensive notes and a built-in commented example project/form to build a couple of example binary trees which output to a gui listbox. Also to demonstrate some of the class member functions usage. You may be surprised to learn there is little emphasis on recursion so no worries of runaway stack levels.(**IMPORTANT**: this latest version includes a major bug fix. When using the data index to reference external data, during a tree rebalance the data index was being lost or mixed up with another. It is a simple fix but significant to keeping the database integrity. This latest version is 1.1 and also includes the functions referenced in the supplemental article). ## LATEST: ## now includes a CD,DVD,Books Media Library application sample. ## (c) David K Richmond
Supplements existing article by similar name and by this author. This is a new release and includes the extra member functions in cBSTNStorage.cls in order to allow node removal. (INCLUDES major bug fix to preserve data index during node removal).
This sample shows how create Excel file using ADOX. In database apps when ADO and ADOX is used it's simple way to create 'Excel reports'. Using ADOX is about 3 times faster than Excel Automation. If you find this code useful, please vote...
adressbook well commented databse
A simple example of database use in VB. Not very well written but may help some people.
Version 1.5 of award winning Wolf DataGrid, fully working data grid now with many new features.
A must for the SQL Server Developer. Combines what developers use with Enterprise Manager and Query Analyser in one package as well as other features including a simple but effective stored procedure debugger, perfect for the beginning SQL developer. Search utility very helpful also. Requires 1024x screen resolution. Can handle multiple selects (max 10) at a time. Be sure to read the readme.txt file for extra features.
This is a gym application that I created for my VB class. This App. keeps track of members, employees and inventory. This program uses MS Access with SQL DAO.
links to the bible allowing searching and indexing of indervidual passages, works using sql and select statements. Program also demonstrates web browser integration and use of the flex grid and shaped forms. you can either select a bible passages or sub chapter etc... or you can enter a passage using the global format, example: Genesis 5(5:9) NOTE ALL BOOKS HAVE A CAPITAL LETTER AND SEARCHES ARE CASE SENSITIVE.There are a few bugs still in this program in relation to back to menu buttons mid wizard and stuff, so be carefull.
This project was developed to help those just starting or wanting to start usind ADO and MYSQL Database. Contains a module that creates a MYSQL database on the fly. Hopefully this will help some of the new people get off the ground with ADO and MYSQL quickly and learn the full capabilites of using this combination. Please read the Program and Module notes before running.
This zip file consist of almost all Database related stuff!!!. Some of the highlights are Dynamic Report Generation Utility with ADO coding, Chart Generation, Datagrid, MSHFlexgrid, And Much More Stuff!!! including searching databasse..... 1> Connection 2> Traversal such as MoveFirst, MoveNext, MovePrevious, MoveLast 3> Manipulation such as Add, Update, Save, Delete 4> A Complete Search Facility 5> Dynamic Report Generation Facility 6> This utility can be esily copy and paste to any of management system...as it is designed as generalise-code which works for all Management System...with little modification according to their requirement. 7> Each Functionality is well explained through needed comment. Plz...rate my work......if you really enjoyed if you want to collect more work than logged-on to http://www.vivekpatel.cjb.net
This project demonstrates how to open the Crystal Report 10 in VB 6 and assign the path of Access db. to the report file. It has uses some function in the VB, like the Formula, RecordsSelectionFormula.... I weak in commenting the code, but hopefully it help some of you. Please give some comments/ critics and vote to me. Before opening the project, please make sure Crystal Report 10 is installed in your Windows, otherwise, the project cannot function normally.
**Niro Professional Address Book** This is my second use of database. This is an address book with password protection, ect... I've worked hard so please vote! Watch up the screen shot!
This is a quiz administration programme. It was created with the military in mind (Navy) so to login you use an official number and a password.There are two groups of users, the administrators and the students. An adminstrator would have access to the questions database (being able to modify it or add new questions), he can also set the conditions for taking the test like number of questions type of questions and duration of test. Only an administrator can register or modify or delete other users. He also has access to all test scores and can prune the database. The questions are stored according to subjects and could be in form of True/False, Multiple Choice or Short Answer type. Each question can be associated with a picture. A student can either take a test of check his scores. All users can change there password anytime. Even though the application was written to suit the military it can easily be modified. Please leave you comments and views, as I am sure I still have a great deal to learn. I have indeed learnt alot from this great site and most of this code can be traced to this site. I am really gratefull to all members of PSC.
Demonstrate the use VB/ ADO to connect to a mySQL server/database / table. Show the records in MSHFlegrid. You can also user sql statement to customize recordset
Whith this class you can load a lisview control with a recorset, and export the data to the TXT, CSV and HTML Format, you can use or not the progressbar.
The purpouse of this module is to backup and restore mysql databases within a Visual Basic program. Please, don't vote for this one... It is a remake of http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=57138&lngWId=1 which inspires me. It has some improvement on his code: Basically, it take the table creation statement directly from the MySQL engine (so now it publish constrains and indexes correctly) and perfom only on insertion statement per table no matter the number of rows in the table. Also, it prevent MySQL from generating errors because of the constraing and block the tables before the insertion process. Also, it could allows the programmers to give feedback to the user about the process and, last but not least, it is IMHO a bit cleaner.